IFERROR Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

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
 
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.
 
Back
Top