Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiplication formula
Hi,
=sum(D1:D20)*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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with multiplication formula
1. iN CELL e20
=SUM(D1:D20)*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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a Formula for Multiplication of Feet and Inches | Excel Worksheet Functions | |||
Ignore blanks in multiplication formula | Excel Worksheet Functions | |||
Addition & multiplication formula | Excel Discussion (Misc queries) | |||
Vlookup and Multiplication formula | Excel Discussion (Misc queries) | |||
one formula to make a multiplication table work | Excel Worksheet Functions |