#DIV/0 Error
Hi,
Try
=IF(D54=0,0,C54/(4*D54))
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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
|