Help Combining Multiple If Statements (Too Many Arguments)

[Nordicrx8]

Hey All!

Scratching my head on this one.

The formula consists of 3 IF statements, 2 of which are IFAND statements. Individually, they all work.

IF(L9<>"",$AG$12

IF(AND($Q9="1xWeekly",$R9="Non-Applicable",$S9="Non-Applicable"),$AG$13:$AG$17)

IF(AND($Q9="1xMonthly",$S9<>""),$AG$12:$AG$13,$AG$12)

I'm able to combine the first two, and it works as intended:

IF(L9<>"",$AG$12,IF(AND($Q9="1xWeekly",$R9="Non-Applicable",$S9="Non-Applicable"),$AG$13:$AG$17,$AG$12))

When I try to add the 3rd statement, I get the "Too many arguments" Error.

=IF(L9<>"",$AG$12,IF(AND($Q9="1xWeekly",$R9="Non-Applicable",$S9="Non-Applicable"),$AG$13:$AG$17),IF(AND($Q9="1xMonthly",$S9<>""),$AG$12:$AG$13,$AG$12))

I'm sure it's something stupid I'm missing, but I've wasted too much time on this and need a second pair of eyes on this one.

Any help is appreciated!

Thank you!

 

[Jon Peltier]

Misplaced closing parenthesis. Try this:

=IF(L9<>"",$AG$12,IF(AND($Q9="1xWeekly",$R9="Non-Applicable",$S9="Non-Applicable"),$AG$13:$AG$17,IF(AND($Q9="1xMonthly",$S9<>""),$AG$12:$AG$13,$AG$12)))

 

[Nordicrx8]

Misplaced closing parenthesis. Try this:

=IF(L9<>"",$AG$12,IF(AND($Q9="1xWeekly",$R9="Non-Applicable",$S9="Non-Applicable"),$AG$13:$AG$17,IF(AND($Q9="1xMonthly",$S9<>""),$AG$12:$AG$13,$AG$12)))

knew it was something stupid - thanks so much!