Looking for basic multiplaction formula

[Concarp]

HI ALL,
I'm trying to multiply cells d5-d9 by cells a5-a9 and
put the answer in cells d14 - d18 ( using caps )
I have tried =(D5*A5)
in d14 and then pulling it down to d18
PLEASE HELP ME IVE BEEN AT THIS FOR AN HOUR AND A HALF!!

 

[Ken Puls]

Sounds to me like you had it right... what's not working?

In cell D14 enter "=D5*A5"
Copy that and paste it in cells D15 to D18.

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

 

[Ken Wright]

You don't need the parenthesis, though that shouldn't stop it working.

As long as your numbers really are numbers (=ISNUMBER(A5) in any cell will
tell you if what is in cell A5 is), then as long as your cells D1418 are
formatted as numeric or general, then in cell D14 you should be able to put
=A5*D5 and drag down and have it work.

If not then describe EXACTLY what you are seeing vs what you expected