How do I create a multiple IF statement?

Janey Morton

I'd like to create an IF statement with multiple questions to determine how close to the next level group. If less than 25, what is the number. If more than 25, 50 - #, etc.

=IF([Sponsor Level total]@row <25, (25-[Sponsor Level total]@row, IF[Sponsor Level total]@row<50, (50-[Sponsor Level total]@row, IF[Sponsor Level total]@row<100, (100-[Sponsor Level total]@row))))

Paul Newcome

You have some misplaced parenthesis.

=IF([Sponsor Level total]@row <25, 25-[Sponsor Level total]@row, IF([Sponsor Level total]@row<50, 50-[Sponsor Level total]@row, IF([Sponsor Level total]@row<100, 100-[Sponsor Level total]@row)))

Paul Newcome

You have some misplaced parenthesis.

=IF([Sponsor Level total]@row <25, 25-[Sponsor Level total]@row, IF([Sponsor Level total]@row<50, 50-[Sponsor Level total]@row, IF([Sponsor Level total]@row<100, 100-[Sponsor Level total]@row)))

Morgan Marquez

Hi there!

Are you able to elaborate on your question a little bit?

Janey Morton

Thank you so much. Putting the parenthesis is the right spot worked perfectly.

Paul Newcome

Happy to help! 👍️