SeveralTradesLater
New Member
- Joined
- May 30, 2023
- Messages
- 14
- Office Version
- 2019
- Platform
- Windows
Hi Excel Community/Smart folks,
What formula would I used to resolve the challenge below? Where,
Assume the product list has 20 or so more products.
Hope someone can assist.
Thank you in advance.
Sheet 1: Rates
Sheet 2: Product Order Form
What formula would I used to resolve the challenge below? Where,
If Cell A2 is Product Category A then D2*C2 , if A2 is Product Category B then D2+E2*C2. |
Assume the product list has 20 or so more products.
Hope someone can assist.
Thank you in advance.
Sheet 1: Rates
| A | B | C | D | |
1 | Product | Fee Percentage 1 | Fee Percentage 2 | Product Category | |
2 | Orange | 15% | 5% | A | |
3 | Apple | 18% | 3% | B | |
4 | Cherries | 33% | 3% | B | |
5 | Banana | 18% | 2% | B | |
Sheet 2: Product Order Form
| A | B | C | D | E | F | G | H | I |
1 | Product Type (Data Validation List Based on Rates Sheet) | Fee Percentage 1 | Fee Percentage 2 | Product Value | Product Value Based on Fee Percentage 1 | Variable Calculation Logic | | | |
2 | Orange | 15% | 5% | $3000 | =D2*B2 | If Cell A2 is Product Category A then D2*C2 , if A2 is Product Category B then D2+E2*C2. | | | |
3 | Apple | 18% | 3% | $2000 | =D3*B3 | " | | | |
4 | Cherries | 33% | 3% | $1000 | =D4*B4 | " | | | |
5 | Banana | 18% | 2% | $3000 | -D5*B5 | " | | | |
| | | | | | | | | |
| | | | | | | | | |
| | | | | | | | | |