I don't know how you produce the values in the four cells, but there
could be a rounding error, inherent in storing decimal numbers in a
binary format, that could cause calculations to produce a very small
number but display as zero.

If B3, C3, etc are supposed to be integers, you can use ROUND(B3,0)0,
etc, to counteract this. If not, you could use ROUND in B3, etc, or
in formulas those cells depend upon, to eliminate the error.

Mark Lincoln

On Oct 18, 2:13 pm, yovation wrote:
hmmm... I decided to try the formula on a clean sheet, and it works
with new data.

Then I tried it again on my original data, and the problem continues
to occur. So I think Excel is seeing something from my data that is0 in a cell that data isn't visible in. I don't have a clue on how

to go about figuring that out. I did a (TRIM(CLEAN( on the data, but
that doesn't make a difference. Very strange.

Thank you.
David