Issues with multiple IF functions?

[janniet]

So what I have is this
=IF(F7 >15, F7*20%, IF(F7 > 1, F7 *10%, F7 *5%))

what i'm trying to do is solve

If a customer purchases 15 or more of any one cake they are able to get a 20% discount on the total cost of the cakes. If they buy more than 1 but less than 15 cakes the discount should be 10%. Any other cakes receive a 5% discount. Cakes are $5.

the problem is, no matter which value i put in, it's only performing a 5% discount with the formula above, for example:
if i put 20 in, for a total of $100, it's giving a discount of $4.

[jeffreybrown]

Hello & Welcome to the Board,

How about this...

=LOOKUP(F7,{1;2;15},{0.05;0.1;0.2})*F7

This should figure out the final price...

=F7*5-LOOKUP(F7,{1;2;15},{0.05;0.1;0.2})*F7

[JBeaucaire]

I think there's a reference missing from this formula. If F7 is the QTY, then what cell holds the "per cake" price... E7? If so, then:

=F7 * (E7 * LOOKUP(F7, {1,2,15}, {1, 0.9, 0.8}))