Salamullah
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 221
Area | Price | Discount 1 | Discount2 | Net price |
A | 100 | 20.5 | 3.78 | 79.5 |
B | 100 | 15.7 | 2.95 | 84.3 |
C | 100 | 11.3 | 1.87 | 88.7 |
A | 20.5% | 4.75% | ||
B | 15.7% | 3.5% | ||
C | 11.3% | 2.105% |
<tbody>
</tbody>
Please help to make single formula in Net price column for example in E2.
IF A2 = A
Discount 1 = B2 X C6
Discount 2 = B2 - C2 X D6
IF A2 = B
Discount 1 = B2 X C7
Discount 2 = B2 - C2 X D7
IF A2 = C
Discount 1 = B2 X C8
Discount 2 = B2 - C2 X D8