varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
I have two tax type
- Slab 1 &
- Slab 2
tax.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | No | Name | QTY | Price | Total Price | Tax Type | Tax Value | Final Price | Desired Output In Column G | ||
2 | 1 | CTI | 5 | 200 | 1000 | Slab 1 | 1000 | 280 | |||
3 | 2 | CTI | 3 | 195 | 585 | Slab 1 | 585 | 205.3 | |||
4 | 3 | TCI | 3 | 200 | 600 | Slab 2 | 600 | 238 | |||
5 | 4 | CCC | 4 | 100 | 400 | Slab 2 | 400 | 192 | |||
6 | 5 | ICN | 3 | 250 | 750 | Slab 1 | 750 | 235 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2:H6 | H2 | =(E2+G2) |
I2:I3,I6 | I2 | =((E2*18)/100)+100 |
I4:I5 | I4 | =((E4*23)/100)+100 |
E2:E6 | E2 | =(C2*D2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =(18/100) |
C2 | C2 | =(23/100) |