| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
Linear Mode
