View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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