Round commission to cents so payroll accepts the file
Commission is 7.5% of revenue, but the calculated numbers carry too many decimals for payroll's import. Each row needs to land at exactly two decimal places. Build the formula once and drag it down so every rep is ready for tomorrow's cutoff.
Round commission to 2 decimals
Practice using ROUND to solve a real finance & accounting problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
Your sales report calculates commission as 7.5% of revenue, but the result has too many decimal places for the payout file. You need it rounded to cents.
In D2, multiply the revenue in C2 by 0.075 and round the result to 2 decimal places.
ROUND rounds a number to a specified number of decimal places. Positive digits round to decimals (ROUND(3.456, 2) = 3.46), zero rounds to whole numbers, negative digits round to tens, hundreds, etc. Excel's standard rule is round-half-away-from-zero.
ROUND(number, num_digits)Try the formula first. Hints cost CP for a reason.