Insira em B3 = C3 * C$2 e depois copie.
C$2 é conhecido como referência de célula mista . Neste caso, como o sinal de dólar ($) é colocado na frente do número da linha (2). Pode ajudar a corrigir o número da linha ao copiar.
Referência: link
Absolute cell references
When a formula contains an absolute reference, no matter which cell the formula occupies the cell reference does not change: if you copy or move the formula, it refers to the same cell as it did in its original location. In an absolute reference, each part of the reference (the letter that refers to the row and the number that refers to the column) is preceded by a “$” – for example, $A$1 is an absolute reference to cell A1. Wherever the formula is copied or moved, it always refers to cell A1.
Relative cell references
In contrast, a relative reference changes if the formula is copied or moved to a different cell (i.e., a cell other than where the formula was originally entered). The row and column portions of a relative reference are not preceded by a “$” – for example, A1 is a relative reference to cell A1. If moved or copied, the reference changes by the same number of rows and columns as it was moved. So, if you move a formula with the relative reference A1 one cell down and one cell to the right, the reference changes to B2.
Mixed cell references
A mixed reference uses a dollar sign either in front of the row letter or in front of the column number, but not both – for example, A$1 is a mixed reference in which the row adjusts, but the column does not. So if you move a formula containing that reference one cell down and one cell to the right, it becomes B$1.