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

http://PrecisionCalc.com
More Power In Excel



On Apr 28, 6:12*am, Gizmo wrote:
I am trying tofinda formula that will give me the least common denominator
for doing a cost account spreadsheet with sales mix.