I am attempting to write a formula using a case statement that evaluates a field to determine a "level". For example if Total_Donations__c is between 1000.00 and 4999.99 then the result will equal "Level 1". There are 5 levels total. I have tried to put the following together but I am doing it incorrectly and have not been able to figure out how to piece it together.
Case (
Total_Donations__c,
(AND(Total_Donations__c > 1000.00, Total_Donations__c < 4999.99), 'Level 1',
(AND(Total_Donations__c > 5000.00, Total_Donations__c < 9999.99), 'Level 2',
(AND(Total_Donations__c > 10000.00, Total_Donations__c < 24999.99), 'Level 3',
(AND(Total_Donations__c > 25000.00, Total_Donations__c < 49999.99), 'Level 4',
Total_Donations__c > 50000.00, 'Level 5',
""
)
)
)
)
)
Can anyone point out what I am doing wrong?