Practice / Arrays

Difficulty 3 of 5 · about 4 min

Fill a column of line totals with one ARRAYFORMULA

Each row of the order has a quantity in column B and a unit price in INR in column C. In D2, write a single formula that fills D2:D7 with the line total including 18% GST for every row: quantity times unit price times 1.18, rounded to 2 decimal places (the cell value must be rounded, not just displayed that way). Use ARRAYFORMULA and do not type anything in D3:D7.

Loading grid…