Not sure how your formula works, as you didn't post it, but perhaps
=NumeratorFormula/DenominatorFormula

and

custom format cell as ???/???

This would automatically reduce your fraction to lowest common denominator.
(including values which are integers, such as 2/1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Caledon" wrote:

I am designing a spreadsheet for aid in my betting calculaions and have hi a
snag which seems beyond me.

The problem is I need to show fractions in their lowest common form i.e. 7/2
and not 13/4 as my formula calculates.

Can anyone help with this small problem.