Variable in Formula

[Schioetz]

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 change Cell B1 to A1 the result of the formula would be 500.

I don't want to use VBA to solve it.... butis that possible.

Thanks in advance for your help.

 

[VoG]

Try

=INDIRECT(B1)*5

 

[Schioetz]

It worked ... thanks for your help