Ratio / Common factor

[rivet]

I understand to get a Ratio you:

Divide both terms of the ratio by the greatest common factor (24/8 = 3, 40/8=5)

State the ratio. (The ratio of 24 to 40 is 3:5)

But can anyone tell me how to find the gereatest common factor between two numbers.

[SlimJim]

I see that you are using a developer edition. The simplest way to calculate it is by a recursive Custom Function. There is a very neat one on Brian Dunnings list here:

http://www.briandunning.com/cf/66

[rivet]

thanks jim