Spyderturbo007
New Member
- Joined
- Mar 11, 2022
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I'm trying to build a pricing sheet that requires user input and then calculates pricing based on multiple entries. I created a matrix, with the help of @Fluff and am able to pull a value for from the matrix for the user input. Once I have that value, there are various modifiers based on the customer selection. Some customers select certain modifiers and others don't select a modifier.
What's the best way to handle something like that in Excel?
For example if someone wants things bagged individually, that's an additional $0.50. If they want custom labels, that is $0.25/each. They can pick and choose and those things get added to the price of the item and then multiplied by the total quantity.
Do I just use a bunch of drop down boxes for Yes / No and then have Excel do a VLOOKUP / HLOOKUP with one having a price of $0 and the other having the price of the option?
Thank you!
What's the best way to handle something like that in Excel?
For example if someone wants things bagged individually, that's an additional $0.50. If they want custom labels, that is $0.25/each. They can pick and choose and those things get added to the price of the item and then multiplied by the total quantity.
Do I just use a bunch of drop down boxes for Yes / No and then have Excel do a VLOOKUP / HLOOKUP with one having a price of $0 and the other having the price of the option?
Thank you!