Hi all
Is it possible to have a variable within an excel formula;
Example: I have values in cell A1=100, A2=200 and A3=300
In cell B1 I will state which of the cells in column A I want to use and multiply by 5
I could look like this:
Cell B1 = A2
Formula; =B1*5 should equal 1000
If I...