help on a formula

[sonia]

Hi

I was wondering if someone can help me with this? i'm not very 'advanced' on
excel, I'm still learning.

I need to keep a formula for eg. =256/3*2
i need to keep the = sign and the /3*2, but the 256 is the only number i
want to change, is there a way i can set it up to do that? in easy to follow
answers??
I keep trying to keep it but get error messages, I don't know what I'm doing
wrong.

Thanks for any help

 

[RagDyer]

Let your formula look at another cell, in which you enter a number to take
part in the calculation.

For instance, enter 256 in A1.

Use this formula:

=A1/3*2

All you now need to do is change the value in A1 to change the results of
the calculation.

 

[Pete_UK]

Type this in cell B1:

= A1 / 3 * 2

and press <Enter>. Then you can put whatever value you want in A1 (eg
256), and B1 will show you the result. Just change the value in A1 by
over-typing, and B1 will change its value.

The formula in B1 can be copied down a few rows, so that you can put
other values in A2, A3, A4 etc to see those results in B2, B3, B4 etc.

Hope this helps.

Pete

 

[sonia]

Thanks very much, that did the trick.

Type this in cell B1:

= A1 / 3 * 2

and press <Enter>. Then you can put whatever value you want in A1 (eg
256), and B1 will show you the result. Just change the value in A1 by
over-typing, and B1 will change its value.

The formula in B1 can be copied down a few rows, so that you can put
other values in A2, A3, A4 etc to see those results in B2, B3, B4 etc.

Hope this helps.

Pete