If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with multiplication formula
1) I want to do the following calculation in cell E20: total of cells D1 to
D20 multiplied by 3. What is the correct formula? 2) Also if I want to add up many RANDOM cells and then multiply the total by one other cell, what is the quickest way? Thanks so much. Excel 2003 |
#2
|
|||
|
|||
Help with multiplication formula
see response to your posting in another group
-- Regards Roger Govier "Josh W" wrote in message ... 1) I want to do the following calculation in cell E20: total of cells D1 to D20 multiplied by 3. What is the correct formula? 2) Also if I want to add up many RANDOM cells and then multiply the total by one other cell, what is the quickest way? Thanks so much. Excel 2003 |
#3
|
|||
|
|||
Help with multiplication formula
Hi,
=sum(D120)*3 for your 2nd question depends on what you want to sum, if that are 3 cells let's say a1 b1 and c1 and the # to be multiplied by is in B10 =(a1+b1+c1)*B10 "Josh W" wrote: 1) I want to do the following calculation in cell E20: total of cells D1 to D20 multiplied by 3. What is the correct formula? 2) Also if I want to add up many RANDOM cells and then multiply the total by one other cell, what is the quickest way? Thanks so much. Excel 2003 |
#4
|
|||
|
|||
Help with multiplication formula
1. iN CELL e20
=SUM(D120)*3 2. Use SUM itself =SUM(a1,a3,a5,a7)*B1 If this post helps click Yes --------------- Jacob Skaria "Josh W" wrote: 1) I want to do the following calculation in cell E20: total of cells D1 to D20 multiplied by 3. What is the correct formula? 2) Also if I want to add up many RANDOM cells and then multiply the total by one other cell, what is the quickest way? Thanks so much. Excel 2003 |
Thread Tools | |
Display Modes | |
|
|