An even easier solution in Google Sheets would be the formula, entered in `C1`

:

```
=ARRAYFORMULA(IF(A5:A,A5:A*(1.6*B5:B),""))
```

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 `C1`

.

The important part is the `:A`

and `:B`

. 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

```
=ARRAYFORMULA(A5:A*(1.6*B5:B))
```

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.