How to make "common factor" formula ?
 

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.

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.




toyota58 wrote:

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.

--

Dave Peterson