Link to home
Start Free TrialLog in
Avatar of Brent Guttmann
Brent GuttmannFlag for United States of America

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,C2<=5000),C2*0.10),AND(C2>=5000,C2<=1000),C2*0.12)



Any help would be appreciated!
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi Brent,

It would be helpful, if you attach a sample workbook.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial