Round down , Round up ?

Hi, I am new to the forum and hoping the experts here can help,

I have a recipe that shows the bag size of each ingredient. Then It shows the total of kilos (of each ingredient) required to make a batch.
I need to show the number of FULL bags required and the # of partial units (kilos) to complete the recipe

I am attaching a quick example

THANK YOU !

How about in E9 enter:
=ROUNDDOWN(D9/B9,0)
and copy down,
and in F9 enter:
=MOD(D9,B9)
and copy down.

Why does your expected results in Row 11 show 4 full bags and 0 kgs when it doesn't take a full 4 bags?

E2: =ROUNDUP(D2/B2,0)

would give the number of 20kg bags needed to provide 690kg aggregate weight of sugar.

E2: =ROUNDDOWN(D2/B2,0) or =INT(D2/B2)

would give the number of bags needed to provide almost all the 690kg aggregate weight to sugar.

Looks like you want the latter.

Thank You Gregb11 ! You are right. It worked !!

Thank You hrIngrv ! I used "INT " . Thank you !