ExcelBanter - IFERROR help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IFERROR help (https://www.excelbanter.com/excel-discussion-misc-queries/183452-iferror-help.html)

Pete DeKalb

IFERROR help

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

IFERROR help

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

Fred Smith[_4_]

IFERROR help

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

All times are GMT +1. The time now is 04:33 PM.