Round number to nearest 1/4, 1/3, 1/2, 2/3, or 3/4 only?

**trickyricky** · 12-11-2010, 03:36 AM

Say I have 5.25 I want to read like 5 1/4. If it's 5.31 I want it to read 5 1/3. If it's 5.74, 5 3/4 etc...

Is there a way?

**zbor** · 12-11-2010, 06:39 AM

Right click on the cell with number
Format cells
Fraction
Up to one digit (1/4)
OK

**shg** · 12-11-2010, 12:09 PM

Try

=INT(A1) + LOOKUP(MOD(A1,1), {0;3;7;10;14;17;21}/24, {0;3;4;6;8;9;12}/12)

... and format the result as # ?/?

**trickyricky** · 12-11-2010, 04:23 PM

shg you're a beast! thank you kindly!

Re: Need Help for formula to round a number to nearest 1/4, 1/3, 1/2, 2/3, or 3/4 onl