Compose a numeric quote and formatted business labels
Build E2:F7. Keep E numeric: gross = units × price rounded to cents; net = gross × (1 − discount) + signed fee rounded to cents; variance = net − target rounded to cents; discount is the original decimal; validity is DATE(year,month,day); units retain their numeric count. F produces exactly Gross: USD / Net: USD / Variance: USD labels with grouped amounts and two decimals, a + only on positive variance, a one-decimal percentage label, an ISO yyyy-mm-dd validity label, and grouped whole units. Zero money is 0.00 with no sign. Build each helper and label separately; do not replace numeric cells with TEXT results. Inputs: units 0–1,000 whole; price/target 0–1,000,000 whole cents; fee ±1,000,000 whole cents; discount 0–1 in steps of 0.0001; a valid date in 1901–2099. English labels and separators are the declared browser contract; native client locales remain separate.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Build E2:F7. Keep E numeric: gross = units × price rounded to cents; net = gross × (1 − discount) + signed fee rounded to cents; variance = net − target rounded to cents; discount is the original decimal; validity is DATE(year,month,day); units retain their numeric count. F produces exactly Gross: USD / Net: USD / Variance: USD labels with grouped amounts and two decimals, a + only on positive variance, a one-decimal percentage label, an ISO yyyy-mm-dd validity label, and grouped whole units. Zero money is 0.00 with no sign. Build each helper and label separately; do not replace numeric cells with TEXT results. Inputs: units 0–1,000 whole; price/target 0–1,000,000 whole cents; fee ±1,000,000 whole cents; discount 0–1 in steps of 0.0001; a valid date in 1901–2099. English labels and separators are the declared browser contract; native client locales remain separate.
No account. No upload. Just try it.