| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formaula to multiply and add
Hi Frank,
another solution: Enter into cell F5: =SUMPRODUCT(C5:E5,{4,9,4}) HTH, Bernd |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formaula to multiply and add
type in f5
sum(c5*4,d5*9,e5*4) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
