Problem with copying formula

  • Thread starter Thread starter jimbob
  • Start date Start date
J

jimbob

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:
 
Set calculation to automatic under tools>calculation 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)
 
Back
Top