#DIV/0 Error

[Dianne HMM]

I have the following formula for numbers containing zero and need a revised
formula to show 0% instead of the #DIV/0

Orig formula i s: =(C54/4)/D54

Helppppp! I'm in a time crunch

 

[Gary''s Student]

=IF(ISERROR(yourformula),0,yourformula)

and format as %

 

[T. Valko]

Try this:

=IF(D54=0,0,(C54/4)/D54)

 

[Gord Dibben]

=IF(OR(D5="",D5=0),0,(C5/4)/D5)


Gord Dibben MS Excel MVP

 

[Shane Devenshire]

Hi,

Try

=IF(D54=0,0,C54/(4*D54))