Menu
Is it possible to declare variables in Excel cells and use them as parameters for formulas in other cells?
For example I would declare var1=10 in one of the cells. In another cell I would use var1 for calculation like: =var1*20.
600
You use Excel variables to retrieve values (logins, passwords, product IDs and so on) from Excel files and insert them into scenarios. Excel variables are similar to list variables, but are linked to a column in an Excel file, not to a static list.
Variable cells (Changing cells or Adjustable cells in earlier versions) are cells that contain variable data that can be changed to achieve the objective. Excel Solver allows specifying up to 200 variable cells.
You can name cells. This is done by clicking the Name Box (that thing next to the formula bar which says "A1" for example) and typing a name, such as, "myvar". Now you can use that name instead of the cell reference:
= myvar*25 If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
