Need IF statement to return a value based on sum between two numbers
This is my "if" statement  where am I going wrong? I am trying to code each line based on a value to help drive other actions
=IF([Total Sum]@row >= $50,000.00, VP, IF(AND([Total Sum]@row <= $2,000.00, [Total Sum]@row > $500.00), A, IF(AND([Total Sum]@row <= $5,000.00, [Total Sum]@row > $2,000.01), SA, IF(AND([Total Sum]@row <= $10,000.00, [Total Sum]@row > $5,000.01), M, IF(AND([Total Sum]@row <= $25,000.00, [Total Sum]@row > $10,000.01), SM, IF(AND([Total Sum]@row <= $50,000.00, [Total Sum]@row > $25,000.01), D))))))
Best Answer

I had to tweek to this, but YES!!! Thank you!!!
=IF([Total Sum]@row >= 50000, "VP", IF(AND([Total Sum]@row <= 2000, [Total Sum]@row > 500), "A", IF(AND([Total Sum]@row <= 5000, [Total Sum]@row > 2000.01), "SA", IF(AND([Total Sum]@row <= 10000, [Total Sum]@row > 5000.01), "M", IF(AND([Total Sum]@row <= 25000, [Total Sum]@row > 10000.01), "SM", IF(AND([Total Sum]@row <= 50000, [Total Sum]@row > 25000.01), "D"
Answers

Try:
=IF([Total Sum]@row >= 50000, "VP", IF(AND([Total Sum]@row <= 2,000, [Total Sum]@row > 500), "A", IF(AND([Total Sum]@row <= 5000, [Total Sum]@row > 2000.01, "SA", IF(AND([Total Sum]@row <= 10000, [Total Sum]@row > 5000.01), "M", IF(AND([Total Sum]@row <= 25000, [Total Sum]@row > 10000.01), "SM", IF(AND([Total Sum]@row <= 50000, [Total Sum]@row > 25000.01), "D")

I had to tweek to this, but YES!!! Thank you!!!
=IF([Total Sum]@row >= 50000, "VP", IF(AND([Total Sum]@row <= 2000, [Total Sum]@row > 500), "A", IF(AND([Total Sum]@row <= 5000, [Total Sum]@row > 2000.01), "SA", IF(AND([Total Sum]@row <= 10000, [Total Sum]@row > 5000.01), "M", IF(AND([Total Sum]@row <= 25000, [Total Sum]@row > 10000.01), "SM", IF(AND([Total Sum]@row <= 50000, [Total Sum]@row > 25000.01), "D"
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!