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?


--
zkayess
------------------------------------------------------------------------
zkayess's Profile: http://www.excelforum.com/member.php...o&userid=17517
View this thread: http://www.excelforum.com/showthread...hreadid=391688