View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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