View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimbob
 
Posts: n/a
Default 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.


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