Is there a formula to calculate the least common denominator?
Actually, that would "Least Common Multiple" and "Greatest Common Divisor".
David Biddulph wrote:
The least common denominator of those numbers is in fact not 5, but
24000000. =LCM(A1,A2)
If you wanted the highest common factor it would be 600000. =GCD(A1,A2)
--
David Biddulph
"Gizmo" wrote in message
...
The numbers I am working with are 3,000,0000 and 4,800,000. I know the
answer is 5. I need to come up with a formula that will give me the
answer
of 5.
"Glenn" wrote:
Gizmo wrote:
I am trying to find a formula that will give me the least common
denominator
for doing a cost account spreadsheet with sales mix.
It might be possible to help if you provided sample data and expected
results.
|