Can you explain how you get an answer of 5 ?

Do you really mean highest common factors ? If so, what about other
factors ?

Take a look he

http://www.helpwithfractions.com/lea...nominator.html

Hope this helps.

Pete

On Apr 28, 3:03*pm, Gizmo wrote:
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.- Hide quoted text -

- Show quoted text -