In Sheets, with amounts in column D, type the row-2 formula for HST at 13 % rounded to the cent, ready to fill down.
In Sheets, with amounts in column D, type the row-2 formula for HST at 13 % rounded to the cent, ready to fill down.
Answer
=ROUND(D2*0.13, 2)
Value, then decimal places. Relative D2 becomes D3, D4, … on the fill. Row 6 (order 1005) gives 171.60.