Formaula to multiply and add
 

I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
formula in cell f5. Can this be done? Thanks for any help

Formaula to multiply and add
 

"Frank Malone" wrote in message
...
I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
formula in cell f5. Can this be done? Thanks for any help

F5 =C5*4+D5*9+E5*4

Bruno

Formaula to multiply and add
 

Hi Frank,

another solution:

Enter into cell F5:

=SUMPRODUCT(C5:E5,{4,9,4})

HTH,
Bernd

Formaula to multiply and add
 

Thanks for the formula works great.

wrote in message
ups.com...
Hi Frank,

another solution:

Enter into cell F5:

=SUMPRODUCT(C5:E5,{4,9,4})

HTH,
Bernd

Formaula to multiply and add
 

Thanks for the formula works great.

"Bruno Campanini" wrote in message
...
"Frank Malone" wrote in message
...
I would like to multiply c5*4, d5*9, e5*4 and then add these all in single
formula in cell f5. Can this be done? Thanks for any help

F5 =C5*4+D5*9+E5*4

Bruno

Formaula to multiply and add
 

type in f5
sum(c5*4,d5*9,e5*4)