Accumulate posted charges after rounding each line
Enter one formula in G5. Return one numeric total for the eight source records. Include only Status equal to Posted under case-insensitive exact matching; do not trim spaces. For each included record, multiply Units by Unit rate and round that line to two decimals, with ties away from zero, before adding it. Retain negative refunds and zeroes. No posted records returns numeric 0. Do not round a combined raw total instead.
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
Enter one formula in G5. Return one numeric total for the eight source records. Include only Status equal to Posted under case-insensitive exact matching; do not trim spaces. For each included record, multiply Units by Unit rate and round that line to two decimals, with ties away from zero, before adding it. Retain negative refunds and zeroes. No posted records returns numeric 0. Do not round a combined raw total instead.
No account. No upload. Just try it.