how do I clear #DIV/0!but leave the formula in cell
 

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

how do I clear #DIV/0!but leave the formula in cell
 

bc;390534 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

bcIts done in this fashion =IF(ISERROR(A1/B1*100),0,A1/B1*100)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109168

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

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