Help with nested IF functions. Help -- I'm so confused.

[grannygamer]

I've been working on this for what seems like hours (probably more like just 1 hour, but time flies....)

I have a worksheet that I'm using to track sales for a certain product. Buyers get discounts for buying larger amounts. If they buy 1-10 items, the cost is $19.99 per. If they buy 11-25, it's 18.99 per; and if they buy more than 25 items, the price is $17.99 per.

Column C is quantity purchased and I want Column D to automatically fill in the appropriate price per each.

So: IF
C28<11, then 19.99
C28>10 AND <25, then 18.99
C28>25 then 17.99,

I've tried many different forumlas, such as:

=IF(((C28<11),19.99,IF((C28>10)AND(C28<25)),18.99,IF((C28>25),17.99))))

And nothing works. I'm almost positive I'm messing up in the second IF value (more than 10, less than 25) and/or with matching my parentheses.

Can someone help me come up with a forumla that will work? I'm really very frustrated at this point.

GrannyGamer (Barbara)

[daddylonglegs]

Try a traditional IF formula.....

=IF(C28="","",IF(C28>25,17.99,IF(C28>10,18.99, 19.99)))

or even, to give the same result....

=IF(C28="","",LOOKUP(C28,{0,11,26;20,19,18})-0.01)

[grannygamer]

Daddylonglegs,

WOW ... you did in a matter of minutes what I've been struggling with for hours. I entered it and it worked perfectly.

I can't thank you enough!!

GrannyGamer