Formula answers incorrect

G

Guest

I have a column in my worksheet that I want to subtract two columns from
eachother. I typed the formula in for the first cell and it gave me the
correct answer. Then when I copied that formula into the other cells, the
answer from the first cell showed up in all the subsequent cells. However,
the forumla changed for all the new copied cells. Here is a sample of what
it is doing.

Column1 Column2 Column3 Formula in column3
10 6 4 A2-B2
5 3 4 A3-B3
20 10 4 A4-B4

As you can see, the formula is correct in cell C3 and C4 but the answer is
the same as cell C2 where I copied the formula from.

Thank you SO much for your help.
 
B

Bob Phillips

Check Tools>Options>Calculation, and make sure Automatic is set, not manual

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Top