#DIV/0! Error

[Jane]

I have the following formula in a cell: =AB15/H14
Cell AB15 contains a 3 and cell H14 contains a zero.
The infamous #DIV/0! error.
I want the cell with the error to return a zero.
How can this be done?

Thank you

 

[Trevor Shuttleworth]

Jane

=IF(H14=0,0,AB15/H14)

Or

=IF(ISERROR(AB15/H14),0,AB15/H14)

Regards

Trevor

 

[Jane]

Thank you so much!

-----Original Message-----
Jane

=IF(H14=0,0,AB15/H14)

Or

=IF(ISERROR(AB15/H14),0,AB15/H14)

Regards

Trevor





.

 

[Trevor Shuttleworth]

You're very welcome.

Thank you so much!