How do I create a multiple IF statement?
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))))
Best Answer
-
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)))
Answers
-
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)))
-
Hi there!
Are you able to elaborate on your question a little bit?
-
Thank you so much. Putting the parenthesis is the right spot worked perfectly.
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!