Using same value to multiply

[exceleron]

Hi,

I need to multiply the values on column F by the rate at N3

I put the formula on the first cel and push it down with the mouse.

It changes the row number correctly but also changes the row number of column N

How can I keep the same cell of column N?

(simple formula: =F21*N3)

thanks

Screenshot 2020-04-02 at 10.05.57.png

[exceleron]

Resolved:
Add $ sign, as in like:

=F21*N$3

[Philb1]

I haven't looked at your example but if you fix the cell with $ it should do what you want
$N$3

[exceleron]

thank , its working