Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any function to determine the smallest common factor from a list?
Does anyone know any build-in feature in excel to determine the smallest /
largest common factor from a list of values? such as 3 6 12, then the smallest common factor will be 3 Thank for any suggestion Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any function to determine the smallest common factor from a list?
..the smallest / largest common factor from a list of values?
=GCD(3,6,12) 3 Returns the greatest common divisor of two or more integers. See LCM also. -- HTH :) Dana DeLouis Windows XP & Office 2003 "Eric" wrote in message ... Does anyone know any build-in feature in excel to determine the smallest / largest common factor from a list of values? such as 3 6 12, then the smallest common factor will be 3 Thank for any suggestion Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any function to determine the smallest common factor from a li
Thank you very much
Eric "Dana DeLouis" wrote: ..the smallest / largest common factor from a list of values? =GCD(3,6,12) 3 Returns the greatest common divisor of two or more integers. See LCM also. -- HTH :) Dana DeLouis Windows XP & Office 2003 "Eric" wrote in message ... Does anyone know any build-in feature in excel to determine the smallest / largest common factor from a list of values? such as 3 6 12, then the smallest common factor will be 3 Thank for any suggestion Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any function to determine the smallest common factor from a list?
And although not mentioned... generally the smallest common factor is
1, which doesn't really need a formula. :-) Scott Dana DeLouis wrote: ..the smallest / largest common factor from a list of values? =GCD(3,6,12) 3 Returns the greatest common divisor of two or more integers. See LCM also. -- HTH :) Dana DeLouis Windows XP & Office 2003 "Eric" wrote in message ... Does anyone know any build-in feature in excel to determine the smallest / largest common factor from a list of values? such as 3 6 12, then the smallest common factor will be 3 Thank for any suggestion Eric |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any function to determine the smallest common factor from a li
Hi scott, u are a wizard..
happy holidays... "Scott" wrote: And although not mentioned... generally the smallest common factor is 1, which doesn't really need a formula. :-) Scott Dana DeLouis wrote: ..the smallest / largest common factor from a list of values? =GCD(3,6,12) 3 Returns the greatest common divisor of two or more integers. See LCM also. -- HTH :) Dana DeLouis Windows XP & Office 2003 "Eric" wrote in message ... Does anyone know any build-in feature in excel to determine the smallest / largest common factor from a list of values? such as 3 6 12, then the smallest common factor will be 3 Thank for any suggestion Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Drop-down list compling with If function. | Excel Worksheet Functions | |||
Subtotals in a list | Excel Discussion (Misc queries) | |||
numerical integration | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions |