#DIV/0! Display

**Pipestew** · 01-17-2007, 03:12 AM

I have several cells that calculate the percentages of certain situations. Some of the situations have not yet occured and therefore result in a division by zero. Is it possible to have the cell display "0%" (or some other specified term) instead of "#DIV/0!" ?

Thanks - Scott

**VBA Noob** · 01-17-2007, 03:32 AM

Hi,

Try a simple if statement

e.g

=IF(ISERROR(B1/C1),0,B1/C1)

VBA Noob

**Pipestew** · 01-17-2007, 03:58 AM

=M37/(M37+M38)

Currently, M37=0 and M38=0, and as a result, the formula results in #DIV/0!

I attempted to use the formula that you suggested, but I may have made a mistake.

=IF(ISERROR(M24/(M24+M25)),0,(M24/(M24/M25)))

When I applied the same formula to cells that were not both 0, I either recieved 100% or the same error.