View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Is there a formula to calculate the least common denominator?

How did you come up with 5 as the answer?


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.