Problem with copying formula
 

I am entering the following formula into Cell L3....

=B4-E3

When I copy this down to the cells below with the drag handle, the
formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result
is the same in every cell which is clearly wrong. I'm stumped.
Thanks.:confused:


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488480

Problem with copying formula
 

Set calculation to automatic under toolscalculation or press F9 after you
have copied down if you for some reason need calculation set to manual

--
Regards,

Peo Sjoblom

(No private emails please)


"jimbob" wrote in
message ...

I am entering the following formula into Cell L3....

=B4-E3

When I copy this down to the cells below with the drag handle, the
formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result
is the same in every cell which is clearly wrong. I'm stumped.
Thanks.:confused:


--
jimbob
------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488480

Problem with copying formula
 

Touch CNTRL-ALT-F9
--
Gary's Student


"jimbob" wrote:


I am entering the following formula into Cell L3....

=B4-E3

When I copy this down to the cells below with the drag handle, the
formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result
is the same in every cell which is clearly wrong. I'm stumped.
Thanks.:confused:


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488480

Problem with copying formula
 

Thanks guys:)


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488480