IFERROR help

[Pete DeKalb]

can i use IFERROR in the following existing formula to remove the "#DIV/0!"
result and replace it with "0": =IF(Input!$AB116=1,M29/M17,M29/(M17+M18))

 

[mike]

You could probably do something like:

=IFERROR(IF(Input!$AB116=1,M29/M17,M29/(M17+M18)),0)

But to be honest I've never used IFERROR() before. I used to use
=IF(ISERROR()), but I think I'll start using IFERROR().

 

[Fred Smith]

Remember, Iferror works only in Excel 2007.

Regards,
Fred.