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!
 
Ad

Advertisements

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

Top