Stuck with Truncate and mod

[Vtookup]

Hello.
I'm confused how to deal with E5 and F5. I know truncates, mod and ifs can be applied here, but still cannot get it. hoping to get help.
Thanks.

 

[Cubist]

Can you explain in words what you are trying to accomplish?

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1
2
3				490	49
4		500
5				1	0	10
6
7
8		1350
9				2	7	27
Data

Cell Formulas
Range	Formula
D5	D5	=INT(B4/D3)
E5	E5	=INT((B4-D3*D5)/E3)
F5	F5	=B4-D3*D5-E3*E5
D9	D9	=INT(B8/D3)
E9	E9	=INT((B8-D3*D9)/E3)
F9	F9	=B8-D3*D9-E3*E9

 

[Vtookup]

How about

Fluff.xlsm
	A	B	C	D	E	F
1
2
3				490	49
4		500
5				1	0	10
6
7
8		1350
9				2	7	27
Data

Cell Formulas
Range	Formula
D5	D5	=INT(B4/D3)
E5	E5	=INT((B4-D3*D5)/E3)
F5	F5	=B4-D3*D5-E3*E5
D9	D9	=INT(B8/D3)
E9	E9	=INT((B8-D3*D9)/E3)
F9	F9	=B8-D3*D9-E3*E9

Hello Fluff.
There's first time for everything. haven't use INT function before.
I'm about to check more of this online and Youtube.
Thank you very much for the help.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[FormR]

Hi, here's another option, the slight advantage here is that the results don't rely on the results of the previous calculations.

Book1
	A	B	C	D	E	F
1
2
3				490	49
4		500
5				1	0	10
6
7
8		1350
9				2	7	27
Sheet1

Cell Formulas
Range	Formula
D5,D9	D5	=INT(B4/$D$3)
E5,E9	E5	=INT(MOD(B4,$D$3)/$E$3)
F5,F9	F5	=MOD(MOD(B4,$D$3),$E$3)

 

[Vtookup]

Hi, here's another option, the slight advantage here is that the results don't rely on the results of the previous calculations.

Book1
	A	B	C	D	E	F
1
2
3				490	49
4		500
5				1	0	10
6
7
8		1350
9				2	7	27
Sheet1

Cell Formulas
Range	Formula
D5,D9	D5	=INT(B4/$D$3)
E5,E9	E5	=INT(MOD(B4,$D$3)/$E$3)
F5,F9	F5	=MOD(MOD(B4,$D$3),$E$3)

Hello FormR

It's nice to have more options.
Originally I have TRUNC(B4/D3) on racks and just got lost in trays and pcs.
Have it been 2 columns like trays and pcs. TRUNC and MOD is my always go to functions
Thanks to Fluff's introduction to INT. and to your MOD application.
Now I have apply them to my past works and future works for shorter formulas.
Thanks Again.