how do I clear #DIV/0!but leave the formula in cell
=IF(iserror(k5/h7*100),0,k5/h7*100)
OR
=IF(iserror((k5/h7)*100),0,(k5/h7)*100)
If this post helps click Yes
---------------
Jacob Skaria
"bc" wrote:
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
|