#DIV/0 Error
=IF(OR(D5="",D5=0),0,(C5/4)/D5)
Gord Dibben MS Excel MVP
On Tue, 17 Mar 2009 10:42:05 -0700, 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
|