I am having a time and a half with something that is probably super easy for anyone else, but here goes...
I have 3 cells:
Cell1 is a dropdown with 3 options (O1, O2, O3).
Cell2 is a Qty
Cell3 is where I would calculate the cost.
For Cell2, I have price breaks for different purchasing volumes: 1-100, 101-200, and 201-300
In a costing table, I have 3 lines, O1, O2, and O3. I then have 3 columns per line, with a discounted price for each Option. The column's pricing is based on volume: 1-100, 101-200, and 201-300.
With all these conditions, I'm banging my head trying to find how to calculate each price based on Option and volume.
Any help is greatly appreciated!
I have 3 cells:
Cell1 is a dropdown with 3 options (O1, O2, O3).
Cell2 is a Qty
Cell3 is where I would calculate the cost.
For Cell2, I have price breaks for different purchasing volumes: 1-100, 101-200, and 201-300
In a costing table, I have 3 lines, O1, O2, and O3. I then have 3 columns per line, with a discounted price for each Option. The column's pricing is based on volume: 1-100, 101-200, and 201-300.
With all these conditions, I'm banging my head trying to find how to calculate each price based on Option and volume.
Any help is greatly appreciated!