Need IF statement to return a value based on sum between two numbers

AHODGE73042

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))))))

AHODGE73042

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"

Nic Larsen

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")

AHODGE73042

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"