~/ learn/ afm-112/ cards/ Data Preparation I: Derived Variables, Text, Dates, and IF
1 of 55

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/1d637167-c58d-497c-a60f-505e5466101d/flashcard utf-8 LF