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?
Bookmarks