Is there a formula to calculate the least common denominator?

G

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding common denominator 2
Count Common Denominator, but excluding "#value!" 4
lowest common denominator 2
Need help with Date/ and find most common denominator. 3
New computer, how do i move outlook 365 ENTIRELY? 0
Excel - Wich Function should I use? 1
How to use/create code in MS Word to calculate age? 0
How to disable Alt+s in Outlook 365 0

Top