Need a formula

[Md Zahirul Islam]

1

2

3

4

5

6

7

8

Product Name

120101026​

Single Bite Beef Samosa 250 gm

15​

250​

201​

15.39​

30.00

30.78

120102040​

Deshi Paratha (Family Pack) 1300 gm [L]

6​

1300​

239.5​

15.39​

120.00

307.81

120102043​

Premium Deshi Paratha 1300 gm [L]

6​

1300​

244.5​

15.39​

180.00

461.71

120104014​

Dal Puri 454 gm [L]

20​

454​

109.5​

21.318​

40.00

42.64

120104015​

Aloo Puri 454 gm [L]

20​

454​

103​

21.318​

40.00

42.64

120105014​

Vegetable Spring Roll 400 gm [L]

18​

400​

112.75​

21.318​

36.00

42.64

120105016​

Mini Chicken Spring Roll 300 gm [L]

20​

300​

182.75​

17.528​

40.00

35.06

120106016​

Mini Singara 300 gm [L]

24​

300​

95.75​

28.536​

48.00

57.07

120108019​

French Fries (Straight Cut) 500 gm [L]

16​

500​

113.5​

28.536​

240.00

428.04

120108020​

French Fries (Straight Cut) 1 Kg [L]

8​

1000​

199.75​

28.536​

24.00

85.61

120112002​

Chicken Momo 250 gm

20​

250​

188​

17.528​

30.00

26.29

120112003​

Chicken Wonthon 300 gm

20​

300​

173​

17.528​

30.00

26.29

120201023​

Chicken Nuggets 300 gm [L]

24​

300​

191.5​

21.318​

144.00

127.91

120202014​

Chicken Sausage 340 gm [L]

36​

340​

209​

21.318​

144.00

85.27

120204003​

Sweet & Hot Wings and Drumlets 500 gm

14​

500​

268​

17.528​

70.00

87.64

120205004​

Chicken Strips 300 gm

16​

300​

221.5​

17.528​

32.00

35.06

120206005​

Pop Chicken 250 gm

25​

250​

203.5​

17.528​

50.00

35.06

120207010​

Chicken Meat Ball 400 gm

24​

400​

232.5​

21.318​

48.00

42.64

120301008​

Fish Ball 200 gm

42​

200​

147​

28.536​

84.00

57.07

Total =

1,430.00

Kg

820.38

Amount

263,312.00

Ltr

2,057.20

[TR]



I have need (7/3)*6=
and last raw of 7th cloumn (2057.20) into last raw of 6th cloumn in one fomula.

 

[Md Zahirul Islam]