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

Very strange behaviour of VLOOKUP in Excel 2010 4
Copying formulas but incrementing the worsheet reference 1
Copying a formula from original cell to mutilpe cells? 3
If Condition 4
Autofiller Tool Help 4
Copy formula - how to keep row the same but incrament the column 4
how to copy a formula to other cells-any shortcut 5
Skip Reference Sequences during copy 3

Top