Calculate rounded charges for paired records
Enter one formula in G5. For each of the eight records in source order, calculate Units times Unit rate plus Adjustment, then round that line to two decimals with half-cent ties away from zero. Return eight numeric charges as one column without headings. Keep zeroes and negative refunds; never sort a single input column separately.
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. For each of the eight records in source order, calculate Units times Unit rate plus Adjustment, then round that line to two decimals with half-cent ties away from zero. Return eight numeric charges as one column without headings. Keep zeroes and negative refunds; never sort a single input column separately.
No account. No upload. Just try it.