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

"Frank Malone" <frank_malone@msn.com> wrote in message
news:%23P$$ltaKGHA.2088@TK2MSFTNGP11.phx.gbl...
>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

Thanks for the formula works great.

"Bruno Campanini" <bruno.campanini@tin.it> wrote in message
news:OP5oQwaKGHA.3960@TK2MSFTNGP09.phx.gbl...
> "Frank Malone" <frank_malone@msn.com> wrote in message
> news:%23P$$ltaKGHA.2088@TK2MSFTNGP11.phx.gbl...
>>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
>

Hi Frank,

another solution:

Enter into cell F5:

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

HTH,
Bernd

Thanks for the formula works great.

<bplumhoff@gmail.com> wrote in message
news:1139075257.137978.82610@g14g2000cwa.googlegroups.com...
> Hi Frank,
>
> another solution:
>
> Enter into cell F5:
>
> =SUMPRODUCT(C5:E5,{4,9,4})
>
> HTH,
> Bernd
>

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