ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In using the formula for Product (A2:A4,2), why times 2? (https://www.excelbanter.com/excel-worksheet-functions/183711-using-formula-product-a2-a4-2-why-times-2-a.html)

Felicia

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)

David Biddulph[_2_]

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)




Felicia

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)





David Biddulph[_2_]

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)








All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com