Excel 2007 formula result

  • Thread starter Thread starter handmgr
  • Start date Start date
H

handmgr

When extending a formula to multiple cells and hit enter, the correct answer
does not appear until I close document and save changes. Then when trying to
add complete column of the answers obtained with fill down formula, answer is
0(zero)
Any ideas will be appreciated.
 
Sounds like you have calculation set to manual. Press F9 to recalculate the
worksheet.
 

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

Excel VBA 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Excel Formula for Eclipsing Circles 0
formula only works when file is saved. 1
Excel formula 1
Countif with indirect formulas needed 0
Rounding in Excel 3
Copied formula produces unexpected copied results 1

Back
Top