Thread: Ignore #DIV/0!
View Single Post
  #3   Report Post  
Stevie_mac
 
Posts: n/a
Default

Something like...

=IF(IsError(A1 / A2), "",A1 / A2)

"DLZ217" wrote in message ...
Can I use an IF function to ignore the #DIV/0 output when making a formula
and if so how and if not what could I use?