Calculate rounded charges for paired records
Your goal: Map quantity, rate and adjustment together, retaining one rounded result for every record.
Full 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.
Signed quantities, half-cent ties and per-line adjustmentsCalculate the charge for source row 2
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 8
Calculate the charge for source row 2
Rules for this step
Select the Units, Unit rate and Adjustment from this one physical row. Round their product plus adjustment to two decimal places; half-cent ties go away from zero.
Calculation rule
ROUND(units × unit rate + adjustment, 2)