Insert Delete Format

Sort &

Filter

$\backslash$table$[[$A$,$B$,$c$,$D$,$E$,$F$],[$Product$,$QTr$,$Price,QTrUsed MXX $1,$aTr Used Mix $2,$aTry Used MIX $3],[$A$,20,$$$60\mathrm{.}95,,,],[B,31,$$$75\mathrm{.}20,,,],[$C$,20,$$$50\mathrm{.}21,,,],[$D$,29,$$$8\mathrm{.}49,,,],[$E$,22,$$$10\mathrm{.}58,$:$.,,],[$Price of Mix$],[,,81,,,],[$Can the Mix be used to make $5$ Batches?,Mix$1,Mx2,$MIX $3],[$Use $=10,,,$E$,,],[,,,,,],[,,,,,],[,,5,,,],[,,-,,,],[,,,,,]]$

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 $$82.$ A fourth click clears the reference.

Examples:

the zero in this function tells the precision of the number. YOU WILL ONLY USE ONE and one of them is better $-$