Ask Your Question

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

asked 2014-01-20 22:40:01 +0200

jr09645 gravatar image

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted

answered 2014-01-20 23:05:17 +0200

oweng gravatar image

updated 2014-01-21 23:49:14 +0200

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.

edit flag offensive delete link more


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

bencomp gravatar imagebencomp ( 2014-01-21 21:43:07 +0200 )edit

Question Tools

1 follower


Asked: 2014-01-20 22:40:01 +0200

Seen: 10,029 times

Last updated: Jan 21 '14