Multiplying A Range
 

Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software

"DanielWalters6" wrote in message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

Dan, if you want to multiply by 10, put 10 in a cell, copy the cell, select
A1:A10, edit, paste special, check multiple, OK

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DanielWalters6" wrote in message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

Assume I have from A1:A10 these values;

1,3,4,5,6,7,4,2,2,6

If I multiply these together, i get 241920

If I sum(a1:a10)*10 then it gives me 400.

Quite a different answer.

Thankyou foryour help allthe same


--
Dan Walters


"Don Guillett" wrote:


?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software

"DanielWalters6" wrote in message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

MsgBox application.fact(10)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"DanielWalters6" wrote in message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

Hi Daniel

Try
=PRODUCT(A1:A10)

--
Regards

Roger Govier


"DanielWalters6" wrote in
message ...
Assume I have from A1:A10 these values;

1,3,4,5,6,7,4,2,2,6

If I multiply these together, i get 241920

If I sum(a1:a10)*10 then it gives me 400.

Quite a different answer.

Thankyou foryour help allthe same


--
Dan Walters


"Don Guillett" wrote:


?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software

"DanielWalters6" wrote in
message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

...Which multiplies all the values in a particular range?

Is "Product" the function you are looking for?

=PRODUCT(A1:A10)

241,920

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"DanielWalters6" wrote in message
...
Assume I have from A1:A10 these values;

1,3,4,5,6,7,4,2,2,6

If I multiply these together, i get 241920

If I sum(a1:a10)*10 then it gives me 400.

Quite a different answer.

Thankyou foryour help allthe same


--
Dan Walters


"Don Guillett" wrote:


?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software

"DanielWalters6" wrote in
message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters

Multiplying A Range
 

Thankyou, Exactly what I needed! :-)
--
Dan Walters


"Roger Govier" wrote:

Hi Daniel

Try
=PRODUCT(A1:A10)

--
Regards

Roger Govier


"DanielWalters6" wrote in
message ...
Assume I have from A1:A10 these values;

1,3,4,5,6,7,4,2,2,6

If I multiply these together, i get 241920

If I sum(a1:a10)*10 then it gives me 400.

Quite a different answer.

Thankyou foryour help allthe same


--
Dan Walters


"Don Guillett" wrote:


?? If I understand
maybe =sum(a1:a10)*10
--
Don Guillett
SalesAid Software

"DanielWalters6" wrote in
message
...
Is there a function, like

=Fact(10)

Which multiplies all the values in a particular range?

=FUNCTIONNAME(A1:A10)

if not, can you suggest a way to do this in VBA?

Dan Walters