Same formula referencing same cells returns incorrect results, randomly, when pasted into new worksh

M

michelleelaine

Please help! I am working with a large chemical dataset with multiple
if/and/isnumber/isblank commands. It works perfectly for one worksheet
but when I try to copy those calculations into another worksheet some
calculations will return blanks when they shouldn't. The strange thing
is that random cells will do this (i.e. HK3 will work correctly and
then HK4 will not). And even odder is the fact that each worksheet has
different cells that don't work properly. I have tried different paste
options, protecting the formulas, using the correctly working
spreadsheet as a template and plugging in new data, etc. and have not
found a solution. If you have any ideas please respond.
Thank you,
Elaine
 
G

Guest

Hi

I think it would help if you posted the formulas you are having problems
with. It may be the type of data in the cells, leading/trailing blanks etc.

Andy.
 

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

Formula results don't change when it's pasted/dragged into a new c 2
Formula won't calculate 4
formula finds values in apparently blank cells 1
Excel formula returns incorrect result 3
Please help with SUM formula dependent on results of other cells 2
Function argument not returning a value 11
Same formula returns different results 1
Excel If statement copy only if ISNumber result is yes 1

Top