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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!