#DIV/0! Error

J

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
 
T

Trevor Shuttleworth

Jane

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

Or

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

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas that refer to a cell in the last row 3
ISTEST Function 7
formula 1
conditional rounding 2
Options for DIV#/0 6
formula 3
If Statement to subtract “time†if condition met 7
Averaging a column that contains text 4

Top