Multi Part IF statement

[Dallas6570]

I am hoping someone can help me with this IF statement

Column I = Quantity ordered
Column J = Price for quantity of 11 or less ($10.00)
Column K = Price for quantity greater than 11 but less than 24 ($9.00)
Column L = Price for quantity of 24 or more ($8.00)

Here is what I have tried and I get an error message saying to many variables.

=IF(I6<=11,I6*J6,IF(I6>11, but<=23,I6*K6,IF(I6>23,I6*L6)))

Any help would be much appreciated

[AliGW]

Try this:

=IF(I6<=11,I6*J6,IF(AND(I6>11,I6<=23),I6*K6,IF(I6>23,I6*L6)))

[Sam Capricci]

there isn't an IF BUT but there is an IF OR and IF AND however you don't need the second IF (I6>11, but<=23) part,
When you have an if / then statement the first time the "THEN" part of the statement that completes the criteria is met the formula stops.
So this should work for you... =IF(I6<=11,I6*J6,IF(I6<=23,I6*K6,IF(I6>23,I6*L6))) and if there is always something in I6 then the last IF could also be omitted like...
=IF(I6<=11,I6*J6,IF(I6<=23,I6*K6,I6*L6))

[Dallas6570]

Great explanation and thank you for your help!!