how to conversion carton ratio to smallest unit

[Rizarusty]

hello

how to conversion carton unit to smallest ratio EX: in 1 carton have 12 boxes and in 1 boxes have 10 pieces.

thank you for helping me with this

[Phuocam]

Try this in H3:

=INT(G3/D3/E3)

in I3:

=INT((G3-H3*D3*E3)/D3)

in J3:

=G3-H3*D3*E3-I3*E3

[Rizarusty]

thank you for your reply, but not working.

what make me confuse is on the middle (box),

in carton i'm using =INT(G3/E3/D3)

and on pcs i'm using mod =MOD(G3,E3)

[torachan]

middle formula should be

=INT((G3-H3*D3*E3)/E3)