divinding error

[Guest]

hi there,

im doing simple division in excel 2003

I'm dividing Cell G18 into H18 (hoever H18 has a value of Zero). when i hit
enter it gives me this error message: #DIV/0!. can you please show me what
in need to do to bypass this erro message.

thanks

 

[Guest]

Use this formula

=if(H18 = 0, 0, G18/H18)

 

[Guest]

=IF(ISERROR(H18/G18)," ", H18/H18) will display nothing if the division
results in an error.