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