Excel → T-SQL › ROUND

Excel ROUND to SQL ROUND

ROUND(amount, 2) is the usual. For money that must match a sheet, test .5 once.

ROUND(total_amount, 2)

CEILING and FLOOR exist too. They are not ROUND.

Canonical translation

ROUND(total_amount, 2)

Then write it on a ticket

Monday is free. A colleague asks, you type, we mark it.

Clock in free