Formaula to multiply and add

F

Frank Malone

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
 
B

Bruno Campanini

Frank Malone said:
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
Click to expand...

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

Bruno
 
B

bplumhoff

Hi Frank,

another solution:

Enter into cell F5:

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

HTH,
Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding cells but leaving blank if not populated 1
IF formula not working 6
Times 2
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
data from 1 sheet to the next 6
Summing from multiple wksts - incomprehensible #VALUE error 7
MATCH INDEX formula required. 3
Move text 1

Top