Aug 09 2021 05:18 PM
I want to calculate product cost and extension based on the quantity entered into a cell. I have 3 different prices based on the quantity entered into a cell. A unit cost for quantities of 1-10, a different unit cost for quantities of 11-100, and a third option for quantities of 101-200. The unit cost will automatically be applied based on the quantity entered into the quantity column. Sound easy enough but I can seem to get it working.
Aug 09 2021 10:11 PM
First of all, please ignore the previous post. I suspect that it is a scam and have reported it to the moderator.
With regard to your question, I would be easiest to create a lookup table where you specify the lower boundaries for the pricing categories. Then use LOOKUP to match the quantity to the correct unit price. I have used named ranges ("lower" and "up") to make the formula easier to read. See attached.