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 F$4$ sets the column $B$2.$ A fourth click clears the reference.

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$2*5)<=$ $B$2,$ "YES", $"$NO$")$