Excel formula - Pricing based on quantity

[Need Formula Help]

I am creating a purchasing form in Excel 2003, Windows XP. The items have a sliding scale for pricing (the more you buy, the cheaper they are). So the Quantity price (N10) in the formula effects the total price. I have three different pricing amounts and can only get two to work. How do I add in the third IF statement to make it work? See formula below:

=IF(ISBLANK(#REF!),IF(ISNUMBER(I10),IF(N10>=I10,N10*L10,N10*K10),N10*K10),IF(ISNUMBER(I10),IF(N10>=I10,N10*L10,N10*K10),N10*K10))

Thank you for your help and let me know if you need more info.

 

[doofusboy]

I only see 2 pricing options in your formula 1) N10*L10 or 2) N10*K10....what is the 3rd option? If it is N10*J10, you could do something like:

'=IF(N10<I10,N10*L10,IF(N10=I10,N10*K10,IF(N10>I10,N10*J10,"")))

 

[doofusboy]

For some reason, last post wouldn't accept my whole formula. Here it is:

sorry, it's just not taking the whole formula for some reason....let me try it in pieces:


<I10,N10*L10, p bit<I10,N10*L10,< first the <---------that?s>IF(N10=I10,N10*K10, <---------that's the second bit
IF(N10>I10,N10*J10,""))) <-------that's the ending bit

...=IF(N10=I10,N10*L10 <-----------first bit



wow......that was weird<I10,N10*L10,< p>

 

[Matty]

If you're trying to include something like a ">" in your formula, doofusby, pad it out with a space either side, otherwise the board software may not recognise it.

Matty

 

[doofusboy]

=if(n10=i10,n10*l10,if(n10 < i10,n10*k10,if(n10 > i10,n10*j10,"")))