troubleshooting Question

Excel Formula Help

Avatar of Brent Guttmann
Brent GuttmannFlag for United States of America asked on
Microsoft OfficeMicrosoft Excel
2 Comments1 Solution46 ViewsLast Modified:
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!
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros