copy a formula

G

Guest

when I try to copy a formula in excel 2003 the original
value appears as the result.
e.g if cell c1 is equal to a1*b1 ,when I drag cell c1
down the sheet the result in cell c2 & c3 etc are the
same as cell c1, even if the figures in a2 & a3 are
different.
This happens for all formulas.
 
N

Nick Hodge

Check that calculation is set to automatic

Tools>Options...Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

VBA Coding Help for Beginner 0
Can a formula do this? 1
Looking to added up based on a character from cell range 1
Need to have data in one column 1
Need help calculating probabilities 7
Data Validation and drop-down list using IF, AND and what else? 8
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Transpose link 5

Top