Answer keeps coming up Zero

March 18, 2009 at 08:20:46
Specs: Macintosh
I am using Mac Excel 2004. I have rows and columns
of numbers using formulas. Everything has been
working properly until now, when I changed the
formula to have the numerical data in a cell in one
worksheet be the data that comes up in the cell in the
other. All I did was change the cell number that the
data is to come from. I have checked and rechecked
numerous times but cannot find any reason why it
suddenly stopped coming up with the right number
and comes up with zero instead. This is happening
now in all the cells in this row except for one. I can
see nothing different in the configuration of this cell
from the others. It doesn't matter now what formula I
use in these cells, the answer always comes up zero.

See More: Answer keeps coming up Zero

Report •


#1
March 18, 2009 at 08:24:39
Could Formatting be the problem?

MIKE


Report •

#2
March 18, 2009 at 08:28:25
Same exact formatting as in the cell that works.

Report •

#3
March 18, 2009 at 08:43:07
Did you specify it was coming from another different sheet?

MIKE


Report •

Related Solutions

#4
March 18, 2009 at 08:46:30
Yes I did. But the cells also are not working when I try any
other formula now. The answer is always 0.

Report •

#5
March 18, 2009 at 08:51:43
2 suggestions:

1 - The standard one: It's kind of hard for us to help based on the limited info you have provided. Basically you are telling us that you had a formula that worked, you changed it and now it doesn't work. You're not giving us very much to work with.

Perhaps if you posted the before and after, that might help.

2 - Have you tried the "Tools...Formula Auditing...Evaluate Formula" feature?

This will allow you to step through the formula and see the results of each part of the formula one by one. I have found this feature invaluable for both troubleshooting and for understanding formulae that I find in worksheets.


Report •

#6
March 18, 2009 at 08:55:39
Based on your latest response, it's very possible that you have a corrupt worksheet.

You can try copying various sections of the worksheet into a new one, avoiding the problem row, and then manually entering the data that you avoided.

You'll obviously run into some errors and bad results during the process, but you might end with a clean worksheet when you are all done.

BTDT


Report •


Ask Question