Hi,

Make a matrix containing the starting number in the range and the price.
For eg.

No.of units price
0 3
11 2

etc and use the formula

=D4*VLOOKUP(D4,$A$1:$B$3,2,TRUE)

where D4 is the given quantity and A1 and B3 is the range where you had
listed out the quantity & prices.

Regards

Govind.


zkayess wrote:
I want to calculate the cost of an item based on the number of units
sold. In other words, 0-10 is $3, 11-20 is $2, 21-30 is $1, and so on.
How do i get excel to compare the inputted number of items to the above
range, and multiply by the associated price?