help on a formula

S

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
 
R

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.
 
P

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
 
S

sonia

Thanks very much, that did the trick.

Pete_UK said:
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
Click to expand...
 
Top