Is there a formula to calculate the least common denominator?

[Gizmo]

I am trying to find a formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.

 

[Greg Lovern]

Hi Gizmo,

The easiest way to do that is with xlpREDUCEFRACTION():

http://precisioncalc.com/xlpREDUCEFRACTION.html

BTW, xlpREDUCEFRACTION is not limited to Excel's 15 significant
digits. It can reduce fractions where the numerator and/or denominator
have as many as 32,767 significant digits.

xlpREDUCEFRACTION can also simplify fractions even where
simplification would not be a reduction, if desired (set the
always_simplify argument to TRUE). For example:

xlpREDUCEFRACTION(2.6,10,,TRUE)

Returns:

13/50


You'll need to download and install the Free Edition of xlPrecision:
(it never expires)

http://precisioncalc.com/xlprecision.html


Thanks,

Greg Lovern
mailto:[email protected]
http://PrecisionCalc.com
More Power In Excel

 

[Greg Lovern]

Hi Gizmo,

The easiest way to do that is with xlpREDUCEFRACTION():

http://precisioncalc.com/xlpREDUCEFRACTION.html

BTW, xlpREDUCEFRACTION is not limited to Excel's 15 significant
digits. It can reduce fractions where the numerator and/or denominator
have as many as 32,767 significant digits.

xlpREDUCEFRACTION can also simplify fractions even where
simplification would not be a reduction, if desired (set the
always_simplify argument to TRUE). For example:

xlpREDUCEFRACTION(2.6,10,,TRUE)

Returns:

13/50


You'll need to download and install the Free Edition of xlPrecision:
(it never expires)

http://precisioncalc.com/xlprecision.html


Thanks,

Greg Lovern
mailto:[email protected]
http://PrecisionCalc.com
More Power In Excel