Hi everyone,
Appreciate if you can advise the formula that is applicable for this scenario.
1. Sheet 1 - table 1
This table shows the price of apples at different minimum order qty (MOQ) in Q2
<tbody>
Types of apple
MOQ 1
Unit price 1
MOQ 2
Unit price 2
MOQ 3
Unit price 3
Apple 1
500...