Solved Excel - Greater Than And Less Than

January 29, 2016 at 06:54:54
Specs: Windows 7
I'm trying to create a formula with the followiing rules:

1) If greater than 0 and less than 8, give a value of 1.95
2) If greater than 7.99 and less than 15, give a value of 2.95
3) If greater than 14.99 and less than 39.99, give a value of 3.95
4) If greater than 39.98 and less than 1000 give a value of 5.95

I've figured out how to do each one individually, but how do I get them to work together in the same statement?

Here is what I have so far:

1) =IF(AND(N7>0,N7<8),1.95)
2) =IF(AND(N7>7.99,N7<15),2.95)
3) =IF(AND(N7>14.99,N7<39.99),3.95)
4) =IF(AND(N7>39.98,N7<300),5.95)

Any help would be greatly appreciated!
Many thanks

See More: Excel - Greater Than And Less Than

Report •

January 29, 2016 at 07:16:37
✔ Best Answer
Your example does not match your statement above it, so I have used your statement.

The easiest way is to cascade down your formula, see how this works:


What you need to figure out, is what happens if the number is GREATER than or EQUAL to 1000?

As given, it will simply blank out cell A1.


message edited by mmcconaghy

Report •

January 29, 2016 at 08:42:37
Thanks SO much, it worked perfectly! A million thanks for your fast response. For the purpose I am using it for the number will never be as high as 1000 so it will work just fine. Thanks again, much appreciated.

Report •

Related Solutions

Ask Question