# How do I multiply 1 number to a range of cells? [closed]

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.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-02-18 17:38:26.690223

Sort by » oldest newest most voted

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.

more