how do I clear #DIV/0!but leave the formula in cell
Try:
=if(h7=0,0,k5/h7*100)
Regards,
Fred.
"bc" wrote in message
...
when i was at work, i used to have an iserror formula. something like
=iserror(k5/h7*100)0(k5/h7*100) , and this would leave 0 in the
formula cell, instead of the above #div/0 thing. but i can't make it
work.
help would really be apreciated.
thanks
bc
|