BBampaa

Lessons › Excel & Google Sheets

Excel & Google Sheets lesson

Absolute references

Lock a cell with $ and fill down

Try this lesson free →
About 5–10 minutes · no sign-up needed

Key points

C2Relative: when you fill down, it slides to C3, C4, C5…
$H$2Absolute: the $ signs lock it, so every row uses H2.
Fill downWrite the formula once at the top, and the sheet copies it down every row.

Put together: =C2*$H$2 uses each row's own revenue, but always the same VAT rate.

Practice

Try each one in your head first, then open the answer.

1. In D2, work out the VAT on Monday's revenue. It fills down to Friday.
=C2*$H$2
2. In E2, work out the price after the discount: revenue times (1 minus the discount). It fills down.
=C2*(1-$H$3)
3. In D2, work out the VAT on each day's revenue. Your formula fills down to Friday.
=C2*$H$2
4. In F2, work out each day's share of the week's total revenue (C7). It fills down.
=C2/$C$7
5. In D2, work out each day's revenue with VAT added on top. It fills down.
=C2*(1+$H$2)

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed