IFERROR Question

[JimS]

I have this formula in Excel 2007

=IFERROR(G14/H14/24,0)

I'm sending this sheet to a friend who has 2000. What formula can I
use to achieve the same result? Otherwise it returns the #DIV/0!
error.

Thanks

 

[Niek Otten]

=IF(ISERROR(G14/H14/24),0,G14/H14/24)

 

[JE McGimpsey]

If you're just checking that H14<>0, the best way (that doesn't mask
other errors):

=IF(H14=0, 0, G14/H14/24)

Of course, given the desired results in your IFERROR() formula, the
above would be better in XL07, too.

 

[JimS]

Thanks to you both. I learned something from both responses.