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" <[email protected]> wrote in message
news:%[email protected]...
>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.

<[email protected]> wrote in message
news:[email protected]...
> Hi Frank,
>
> another solution:
>
> Enter into cell F5:
>
> =SUMPRODUCT(C5:E5,{4,9,4})
>
> HTH,
> Bernd
>

Thanks for the formula works great.

"Bruno Campanini" <[email protected]> wrote in message
news:[email protected]...
> "Frank Malone" <[email protected]> wrote in message
> news:%[email protected]...
>>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
>

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