Nested IF Function Help

dgarnas

I am struggling to get this formula to work. Any thoughts?

=IF(([FY26 Membership Level]@row = "Basic", "$2,000", IF[FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF[FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF[FY26 Membership Level]@row="Intensive Level 1", "$15,000",IF[FY26 Membership Level]@row="Intensive Level 2", "$24,000"),"$0")

ECarlson_PCG

=IF([FY26 Membership Level]@row = "Basic", "$2,000", IF([FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF([FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF([FY26 Membership Level]@row="Intensive Level 1", "$15,000", IF([FY26 Membership Level]@row="Intensive Level 2", "$24,000", "$0")))))

^ Added a space before the last "IF" to this version and moved the closing ).
Additional question: is it finding the correct column reference when you add the formula to your sheet? All the "[FY26 Membership Level]@row" references become colors?

ECarlson_PCG

You're missing some ( after the IF in the nested IFS of your formula. Update for you below.

What do you want to accomplish at the end? All IFs, otherwise "$0"? written as such:

=IF([FY26 Membership Level]@row = "Basic", "$2,000", IF([FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF([FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF([FY26 Membership Level]@row="Intensive Level 1", "$15,000",IF([FY26 Membership Level]@row="Intensive Level 2", "$24,000")))),"$0")

dgarnas

Thank you ECarlson! I tried your formula, I got the error "Incorrect Argument Set". Yes, all IFs otherwise "$0", to answer your question. Any other ideas?

ECarlson_PCG

=IF([FY26 Membership Level]@row = "Basic", "$2,000", IF([FY26 Membership Level]@row="Enhanced Level 1", "$8,000", IF([FY26 Membership Level]@row="Enhanced Level 2", "$12,000", IF([FY26 Membership Level]@row="Intensive Level 1", "$15,000", IF([FY26 Membership Level]@row="Intensive Level 2", "$24,000", "$0")))))

^ Added a space before the last "IF" to this version and moved the closing ).
Additional question: is it finding the correct column reference when you add the formula to your sheet? All the "[FY26 Membership Level]@row" references become colors?

dgarnas

This worked, thank you so much ECarlson!!

ECarlson_PCG

Oh great! Glad to hear. :)