divinding error

T

trinni

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
 
E

Elisabeth

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