help on a formula
 

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

help on a formula
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"sonia" wrote in message
...
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

help on a formula
 

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


On Jul 22, 12:44*am, sonia wrote:
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

help on a formula
 

Thanks very much, that did the trick.

"Pete_UK" wrote:

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


On Jul 22, 12:44 am, sonia wrote:
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