incorrect answer

[Excelski]

Hi All,

What am I missing, when I drag the answer in N10 down it displays the wrong result?

Thanks

Kevin

[azumi]

Im confused here, all the answer is display correctly
N10=10
N11=15
N12=20
N13=25

[MrShorty]

More explanation -- namely, what incorrect answer are they showing -- because all four cells appear correct to me:
N10=10
N11=15
N12=20
N13=25

The only reason off the top of my head that a copied cell like this would not show the correct result is if you have turned automatic calculation off, in which case, the copied cells will usually show the same result as the original cell. If you are copying N10, for example, N11:N13 would all show 10, until you manually command a calculate event. Is that what you are seeing, or are you seeing other behavior?

[Excelski]

When I drag N10 down all the answers displayed as 10
When I reopen the file the answers are correct

[peterrc]

Hi,

You have calculation set to Manual.
Select the Formula Tab in the ribbon
Select Calculation Options and change to Automatic.
Then copy down.

Regards

peterrc