An even easier solution in Google Sheets would be the formula, entered in
It will automatically replicate ("Continue") to succeeding rows if a value is entered in column A.
No need to copy it to each row, In fact, if you copied it to
C2 it would be automatically overwritten by the continuation of the formula in
The important part is the
:B in the formula. That indicates which entire columns you want included in the formula.
So for a single cell formula of
=A5*(1.6*B5), you would apply this to entire columns with
This will give bad results where you don't have any values in rows A and B, so thus we add the
IF() statement (as above) to show nothing when there are no values.