Solved Excel - Greater Than And Less Than

January 29, 2016 at 06:54:54
Specs: Windows 7
Hello,
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 •

#1
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:

=IF(A1<8,1.95,IF(A1<15,2.95,IF(A1<39.99,3.95,IF(A1<1000,5.95,""))))

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.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
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