harsharmani
New Member
- Joined
- Oct 29, 2017
- Messages
- 7
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
please help me and do the need full |
<tbody>
</tbody>
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
please help me and do the need full |
minimum order qty 5 | minimum order qty 10 | minimum order qty 15 | Quantity required | price | |
apple | 14 | 12 | 10 |
Prod | Rate 5 | Rate 10 | Rate 15 | Qty | Price |
Apple | 14 | 12 | 10 | 20 | 200 |
This small table does what your table requires:
Prod Rate 5 Rate 10 Rate 15 Qty Price Apple 14 12 10 20 200
<tbody>
</tbody>
This goes from Col A to Col F.
The formula in F2 is:
=IF(E2<5,"N/A",IF(AND(E2>4,E2<10),E2*B2,IF(AND(E2>9,E2<15),E2*C2,E2*10)))
Not: I have included the situation where a value below your lowest value is reported as Not Available, it is not a computer error.
I was thinking that the customer's minimum order was 5 and so I structured the formula around that value.table woud be
minimum order qty 5 minimum order qty 10 minimum order qty 15 Quantity required price apple 14 12 10
<tbody>
</tbody>