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