View Single Post
 
Old 11-04-2015, 05:08 AM
Jason167 Jason167 is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2015
Posts: 2
Jason167 is on a distinguished road
Default Multiplying an entire column by a single cell

Hi All

Firstly I'm sorry if this question is a little basic but I'm new to Excel and am struggling to with this problem.

I'm using excel 2007 and trying to multiply an entire column by the value of a single cell to produce another column of answers

Therefore

If cell A1 has a value of 10

And column D has 50 cells each with different values

I want to multiply each value in column D by the value in Cell A1 and produce 50 answers in column E
Reply With Quote