Remember, Iferror works only in Excel 2007.

Regards,
Fred.

"mike" wrote in message
...
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().



"Pete DeKalb" wrote:

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))