How do I multiply 1 number to a range of cells?

[jr09645]

I have been trying to figure out how can I write a formula that will multiply one number to each cell within a table on a spreadsheet.
Each number in the cells needs to multiplied by the same number. I want to be able to change that one number as price increases happen.
I can’t seem to get it any help would be great.

[oweng]

Given an array (table) of numbers (e.g., A1:C3) and a single other multiplier (e.g., D1), you are going to need a second array for the formulas (answers) to go (e.g., E1:G3). Use relative addressing to refer to the first cell in the first array (e.g., A1) and absolute addressing to refer to the multiplier (e.g., $D$1). For example,

1. In E1 enter =A1*$D$1.
2. Click and drag this cell to G1.
3. With E1:G1 still highlighted, click and drag this cell range to G3.

EDIT: Also refer this answer.

[bencomp]

You could also select the D1 cell, give it a name and use the name in formulas.