Posted by Mason on December 13, 2001 10:14 AM
In cell H9 I have a formula:
A9 cell is formatted as "currency"; D9 is also formatted as currency.
If there are dollar amounts in D9 and A9, the percentage is displayed properly.
If there are zero dollars in D9, and a dollar amount in A9, 0% is displayed.
However, if there is a dollar amount in D9, are zero dollars in A9, then the #DIV/0! error is displayed.
Same thing if both D9 and A9 are zero dollars, the #DIV/0! error is displayed.
So anytime that A9 has zero dollars, I get #DIV/0! error.
I checked Help, and have tried the formula:
But instead of getting a null in H9, I get the #VALUE! error.
How can I get a null value in H9? And why is D9 in parentheses in the =SUM(D9)/A9 formula?
Thanks, very much!