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.95I'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

Your example does not match your statement above it, so I have used your statement. The easiest way is to

cascadedown 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

message edited by mmcconaghy

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.

Ask Your Question

Weekly Poll