How to make "common factor" formula ?

T

toyota58

Hi,


I'm an Excel newbie. I want to make a simple "common factor" formula.
But I don't know what function to use or the formula.

Example

A1 = 369
A2 = 468
A3 = common factor is 6


Another Example

A1 = 355
A2 = 145
A3 = 225
A4 = common factor is 5



Thank You.
 
D

Dave Peterson

There's an =GCD() (greatest common divisor) in the analysis toolpak:

=gcd(369,468)
returned 9.

=gcd(a1:a3)
(with your data in A1:A3)
returned 5.

If you get a #name! error, tools|Addins and check analysis toolpak.
 
Top