How to convert a static formula to dynamic formula ?
 

I'm using relative referencing, but what exactly happening is when I copy the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is
=A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is
the value not changing ?

I'm aware of absolute referencing and i've checked for the $ sign in the
formula and there aren't any.

How to convert a static formula to dynamic formula ?
 

Check that you don't have manual calculation set, ToolsOptionsCalculation,
there are option buttons for Automatic and Manual.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Pisistratus" wrote in message
...
I'm using relative referencing, but what exactly happening is when I copy
the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2
is
=A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why
is
the value not changing ?

I'm aware of absolute referencing and i've checked for the $ sign in the
formula and there aren't any.

How to convert a static formula to dynamic formula ?
 

probably it is not the referencing but that you need to go to
toolsoptionscalculations and select automatic.

"Pisistratus" wrote:

I'm using relative referencing, but what exactly happening is when I copy the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is
=A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is
the value not changing ?

I'm aware of absolute referencing and i've checked for the $ sign in the
formula and there aren't any.

How to convert a static formula to dynamic formula ?
 

You probably have the sheet set to manual calculation - press F9 to
force a re-calculation. Go to Tools | Options | Calculation tab and
check Automatic and OK.

Hope this helps.

Pete

On Jul 5, 1:42 pm, Pisistratus
wrote:
I'm using relative referencing, but what exactly happening is when I copy the
formula i.e =A1+B1 from Cell C1 to Cell C2, the formula copied in Cell C2 is
=A2+B2 as expected, but the value is of Cell C1 i.e value of =A1+B1. why is
the value not changing ?

I'm aware of absolute referencing and i've checked for the $ sign in the
formula and there aren't any.