ExcelBanter - I want to multiply a serie of numbers by a fixed cell.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - I want to multiply a serie of numbers by a fixed cell. (https://www.excelbanter.com/new-users-excel/120897-re-i-want-multiply-serie-numbers-fixed-cell.html)

Tim

I want to multiply a serie of numbers by a fixed cell.

put "$" so it will look like =($A$1*D4) this will make the A1 absolute
reference, hop this helps.

"Nuno" wrote:

What is the symbol I shall put before the reference of the fixed cell?

All times are GMT +1. The time now is 03:40 PM.