Excel

Complete the Spreadsheet using $=$SUMPRODUCT$()$; ROUNDUP$(,0)*$ or Round$(,0)*$;

and if$()$ functions. Everything in yellow needs a value.

Use the F$4$ KEY to set values to absolute reference or partial reference when

making your equations. F$4$ makes it absolute$.$ A second click on F$4$ sets the Row

$B$$$2.$ A third click on $F4$ sets the column $$B2.$ A fourth click clears the reference.

Can the Mix be used to make $5$ Batches?

Examples:

$=$ ROUND$($$B$$2*$B$17,0)$ or $=$ROUNDUP$($$B$2,$ B$17,0)$

$=$SUMPRODUCT$($$C$$2$:$C$$6,$ D$2$:D$6)$

$=$ IF$(($D $B$2,$ "YES", $"$NO$")$

the zero in this function tells the precision of the number. YOU WILL ONLY USE

ONE and one of them is better $-$