Hi, everyone!
I'd love some help!
Using the Mac version of Excel I've created a spreadsheet with multiple formulas. Each cell and formula within is similar to...
=0.25*1
...where the value of 25 is constant and the number 1 is variable.
To date I have been editing this variable by changing its value in the formula bar. This, however, becomes tedious (and prone to error) as there are several dozen such variables inside cells to change.
A better solution would be to simply click on that cell, =0.25*1, enter a new variable into the cell itself, and have the cell display a new value.
Is it possible to program/set up Excel to do this?
Bookmarks