Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In using the formula for Product (A2:A4,2), why times 2?
I don't understand, (I know I forgot this part of math), why I would multiply
by 2 - why do I need to double my answer? Thanks, Felicia (totally forgot) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In using the formula for Product (A2:A4,2), why times 2?
We don't know, because we don't know what your formula is trying to
calculate. If your formula is =PRODUCT(A2:A4,2), the result will be =A2*A3*A4*2, but while we can see the answer, we don't know the question for which you decided that formula was the answer. -- David Biddulph "Felicia" wrote in message ... I don't understand, (I know I forgot this part of math), why I would multiply by 2 - why do I need to double my answer? Thanks, Felicia (totally forgot) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In using the formula for Product (A2:A4,2), why times 2?
Thanks, I got the formula from the Micro-soft excel help page as an example
and I was just trying to figure out why I would multiply by 2 in the end for this particular example- thanks anyway.... "David Biddulph" wrote: We don't know, because we don't know what your formula is trying to calculate. If your formula is =PRODUCT(A2:A4,2), the result will be =A2*A3*A4*2, but while we can see the answer, we don't know the question for which you decided that formula was the answer. -- David Biddulph "Felicia" wrote in message ... I don't understand, (I know I forgot this part of math), why I would multiply by 2 - why do I need to double my answer? Thanks, Felicia (totally forgot) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In using the formula for Product (A2:A4,2), why times 2?
In the help example, A2 to A4 contain 5, 15 and 30 respectively.
The example then says: " =PRODUCT(A2:A4) Multiplies the numbers above (2250) =PRODUCT(A2:A4, 2) Multiplies the numbers above and 2 (4500) " This is merely illustrating that the arguments of the PRODUCT function can be either cell references or numbers, or both. From the earlier part of the help for that function: "Multiplies all the numbers given as arguments and returns the product." ... "Arguments that are numbers, logical values, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers cause errors. If an argument is an array or reference, only numbers in the array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored. " -- David Biddulph "Felicia" wrote in message ... Thanks, I got the formula from the Micro-soft excel help page as an example and I was just trying to figure out why I would multiply by 2 in the end for this particular example- thanks anyway.... "David Biddulph" wrote: We don't know, because we don't know what your formula is trying to calculate. If your formula is =PRODUCT(A2:A4,2), the result will be =A2*A3*A4*2, but while we can see the answer, we don't know the question for which you decided that formula was the answer. -- David Biddulph "Felicia" wrote in message ... I don't understand, (I know I forgot this part of math), why I would multiply by 2 - why do I need to double my answer? Thanks, Felicia (totally forgot) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
product formula not totaling | Excel Worksheet Functions | |||
formula for product not working | Excel Worksheet Functions | |||
Sum product the right formula? | Excel Discussion (Misc queries) | |||
formula for - price times discount times tax = final price | New Users to Excel | |||
Product formula help | Excel Worksheet Functions |