What is ISERROR

Hi,

This formula has the word 'ISERROR'. Is this a system code ID? Does this mean if the division caused error, then give 0 or do the division accordingly?

=IF(ISERROR(AF7/S7),0,AF7/S7)

Thanks.

You got it... If the division causes an error, then return 0 else do the division.

It might be benificial for you to take a look at the Excel help for issues with these formulas, it might save you some time in understanding what they mean.

Hi,

Will do... Thanks for getting me on the right path. I just have to translate these formulas and report the results by tomorrow. I thought I'd get some help from the experts rather than figuring it out first because I could have been on the wrong path.

Regards