How to convert box, bale, slop, pack data automatically to pcs

[Ankga]

How to convert box, bale, slop, pack data automatically to pcs ?
Welcome to MrExcel
Please guide all teachers
How to convert box, bale, slop, pack data to pcs.

Example:
1 box = 4 bales
1 bales = 20 slop
1 slop = 10 pack
So 1 box = 800 pcs

If one product comes out with the number of
3 boxes, 2 bales, 10 slops, 5 packs
Then the pcs result is 3705 pcs

Please guide me, How is the formula

 

[SunnyAlv]

3 boxes, 2 bales, 10 slops, 5 packs
Then the pcs result is 3705 pcs

How does this result in 3705 pcs?

3 Boxes = 2400 pcs (800 pcs * 3 boxes)
2 Bales = 400 pcs (200 pcs * 2 Bales)
10 Slops = 100 pcs (20 pcs * 10 Slops)
5 Packs = 5 pcs (1 pcs * 5 Packs)

Total = 2905

 

[Ankga]

Bagaimana ini menghasilkan 3705 pcs?

3 Kotak = 2400 pcs (800 pcs * 3 kotak)
2 Bale = 400 pcs (200 pcs * 2 Bale)
10 Slop = 100 pcs (20 pcs * 10 Slop)
5 bungkus = 5 buah (1 buah * 5 bungkus)

Jumlah = 2905
View attachment 106370

Maaf, saya salah perhitungan
Tolong ajari saya rumus untuk kolom seperti ini

 

[SunnyAlv]

10 Slops = 100 pcs (20 pcs * 10 Slops)

200*

 

[SunnyAlv]

Try this

in Cell "H3"

=SUM(D3*800,E3*200,F3*20,G3*1)

 

[Ankga]

Terima kasih

Coba ini

pilih "H3"
[KODE=xls]=JUMLAH(D3*800,E3*200,F3*20,G3*1)[/KODE]

View attachment 106372

Coba ini

di sel "H3"
[KODE=xls]=JUMLAH(D3*800,E3*200,F3*20,G3*1)[/KODE]

View attachment 106372

Thx a lot bro i will try this formula

 

[SunnyAlv]

Terima kasih



Thx a lot bro i will try this formula

sama sama

no problem