Hi, Is there any way to get excel to round fractions to the nearest "1/x" value? I currently have a fraction shown as 4/953 and want this shown as a "1/x" value instead e.g. the denominator can be any value but I want the numerator to be 1. I realise that this will mean loosing accuracy in the value.

I need an excel formula that will work for any fraction.

Thanks