Kalpesh123
New Member
- Joined
- Dec 30, 2018
- Messages
- 22
I have 3 type formula need to apply different row
A select witch formulae need to apply
ROW2 ROW3 ROW4 ALL IS DIFFERENT FORMULAE
Some time i need apply same like row2 /row 3/row 4
then how to manage that all formulae in one sheet to
please give me some guide about it
A select witch formulae need to apply
ROW2 ROW3 ROW4 ALL IS DIFFERENT FORMULAE
Some time i need apply same like row2 /row 3/row 4
then how to manage that all formulae in one sheet to
please give me some guide about it
A | B | C | D | E | F | G | H | I | J | |
1 | Type | price | qty | tax | exp 1 | exp 2 | total | Net | ||
2 | INT | 10 | 15 | =(b1*c1)*10% | =(b1*c1)*.25% | =(b1*c1)*.45% | =(b1*c1)-d1-e1-f1 | =g2 | ||
3 | DL | (-13) | 10 | =(b1*c1)*18% | =(b1*c1)*.40% | =(b1*c1)*.20% | =(b1*c1)+d1+e1+f1 | =h3+g2 | ||
4 | SL | 15 | 10 | =(b1*c1)*18% | =(b1*c1)*.75% | =(b1*c1)*5% | =(b1*c1)-d1-e1-f1 | =h4+g3 | ||
5 | INT | |||||||||
6 | INT | |||||||||
7 | DL | |||||||||
8 | SL | |||||||||
9 | DL | |||||||||
10 | SL |