Accumulate posted charges after rounding each line
Your goal: Use a declared zero initial state, select posted records and add individually rounded signed charges.
Full 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.
Round each posted record before accumulatingChoose every Posted record
| # | ||||
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 | ||||
| 9 |
Step 1 of 9
Choose every Posted record
Rules for this step
Compare the whole status with Posted without letter case. Spaces are literal. Include matching negative and zero rows; duplicate labels do not merge physical records.