Looking for basic multiplaction formula
 

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!!

Looking for basic multiplaction formula
 

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

Concarp wrote:
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!!

Looking for basic multiplaction formula
 

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 D14:D18 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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"Concarp" wrote:

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!!