IF THEN constructs

Copper Contributor

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.

1 Reply

@Gene_LaValle 

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.

 

Screenshot 2021-08-10 at 07.10.00.png