Problem with copying formula

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:
 
P

Peo Sjoblom

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula from original cell to mutilpe cells? 3
Autofiller Tool Help 3
Copy formula - how to keep row the same but incrament the column 4
Formula not working 1
Very strange behaviour of VLOOKUP in Excel 2010 4
Question about Copy/Paste functions 4
If Condition 4
Gerneralising/autofilling an Equation 1

Top