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

and format as %
--
Gary''s Student - gsnu200839


"Dianne HMM" wrote:

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
--
Dianne