Help combining ISERROR with IF statements

[Guest]

Hello all,

I'm new to this forum, but I'm just wondering does anyone have any suggestions as to how I could use an ISERROR to trap the results of my calculations on each line. I've tried numerous times but I'm stuck on the brackets and it keeps telling me I have too many arguments. Grrr!

=IF('Step 1'!B6<=2,SUM('Step 2'!C1315)/COUNTIF('Step 2'!C1315, "<>NA"),
IF('Step 1'!B6<=5,SUM('Step 2'!C13:E15)/COUNTIF('Step 2'!C13:E15, "<>NA"),
IF('Step 1'!B6<=10,SUM('Step 2'!C13:F15)/COUNTIF('Step 2'!C13:F15, "<>NA"))))

Any help I can get would be greatly appreciated.

Thanks

 

[RagDyer]

You should perform the error trapping within the formula that's *causing* it
(#NA) to be returned in the first place.
That will also enable you to use a single "Average" function instead of
using the Sum and Countif functions together.
Post the formula that's returning the #NA error if you need help, or follow
this generic syntax:
=IF(ISERROR(your formula),"",your formula)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello all,

I'm new to this forum, but I'm just wondering does anyone have any
suggestions as to how I could use an ISERROR to trap the results of my
calculations on each line. I've tried numerous times but I'm stuck on the
brackets and it keeps telling me I have too many arguments. Grrr!

=IF('Step 1'!B6<=2,SUM('Step 2'!C1315)/COUNTIF('Step 2'!C1315, "<>NA"),
IF('Step 1'!B6<=5,SUM('Step 2'!C13:E15)/COUNTIF('Step 2'!C13:E15, "<>NA"),
IF('Step 1'!B6<=10,SUM('Step 2'!C13:F15)/COUNTIF('Step 2'!C13:F15,
"<>NA"))))

Any help I can get would be greatly appreciated.

Thanks