Brent Guttmann
asked on
Excel Formula Help
I’m trying to create a formula for Column “D” that will tell me the percentage of Column “C” based on the range the number in Column “C” is.
For example: If greater than 0 and less than 2500 = 8%, If greater than 2500 and less than 5000 = 10%, If greater than 5000 and less than 10000 = 12%, etc., etc.
1 A B C D
2 TEXT TEXT NUMBER FORMULA
3 TEXT TEXT NUMBER FORMULA
4 TEXT TEXT NUMBER FORMULA
5 TEXT TEXT NUMBER FORMULA
6 TEXT TEXT NUMBER FORMULA
I was able to get this formula that work for the “If greater than 0 and less than 2500 = 8%”
=IF(AND(C2>=0,C2<=2500),C2 *0.8)
When I try to add the additional percentages it does not work even on the first piece:
=IF(AND(C2>=0,C2<=2500),C2 *0.8),AND( C2>=2500,C 2<=5000),C 2*0.10),AN D(C2>=5000 ,C2<=1000) ,C2*0.12)
Any help would be appreciated!
For example: If greater than 0 and less than 2500 = 8%, If greater than 2500 and less than 5000 = 10%, If greater than 5000 and less than 10000 = 12%, etc., etc.
1 A B C D
2 TEXT TEXT NUMBER FORMULA
3 TEXT TEXT NUMBER FORMULA
4 TEXT TEXT NUMBER FORMULA
5 TEXT TEXT NUMBER FORMULA
6 TEXT TEXT NUMBER FORMULA
I was able to get this formula that work for the “If greater than 0 and less than 2500 = 8%”
=IF(AND(C2>=0,C2<=2500),C2
When I try to add the additional percentages it does not work even on the first piece:
=IF(AND(C2>=0,C2<=2500),C2
Any help would be appreciated!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It would be helpful, if you attach a sample workbook.