Hi,

Basically, the formula converts a percentage value to a number and the
resultant answer is formatted with ??/?

=IF(C6="","",(1/E6)-1)

In this instance C6 = 9/4 and E6 23.4%

This produces the fraction 13/4 when formatted.... this is my problem as
this is 7/2. I want to reduce the fraction to one that is recognisible in
betting terms.

Hope this makes things clearer.

Derek

"Luke M" wrote:

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.