Formulas not copyingh/calculating correctly

C

Chris Huck

I'm trying to copy a formula to multiple cells in the same
column, simple division. I've tried drag and fill or just
copy/paste. The formulas copy correctly, ie. the correct
CR/CR appears in the cell; however, the formula result is
incorrect--it takes the result from the copied cell and
displays in any pasted cell. It's behaving very buggy,
and my next option is a reinstall if I can't figure this
out. Help!
 
F

Frank Kabel

Hi Chris
maybe the calculation mode is set to manual. Does hitting F9 change the
results??

Frank
 

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

How do I ensure formulas automatically calculate after pasting 1
using the =page! feature to transpose a row to column 0
Excel VBA 1
Repeat formula for all cells in whole column 1
Formula results don't change when it's pasted/dragged into a new c 2
Formula results display only after pressing Enter key 1
Time Sum in Excel 1
E2007 formulas display as formulas, not results 3

Top