On Fri, 4 Dec 2009 09:09:02 -0800, Dianna Michelle <Dianna
wrote:

I have a calculated number that I want to display to the ½ fraction. The
fraction format rounds up.
Even if I use the rounddown to get the number I want, when I format the cell
to the half fraction, it rounds my number back up again. I’ve tried
increasing the decimal places of the original calculated number and that
doesn’t help.

I’m trying to calculate paid days earned (based on hours worked).

Even if you work enough hours to get 1.49999999999999 days, you don’t get 1
½ days until you cross the 1.5 boundary.

You did not post your formula, but I suspect you are not using the ROUNDOWN
function properly.

To ROUNDOWN to the nearest 1/2:

=ROUNDDOWN(A1/(1/2),0)*1/2

or, more simply:

=ROUNDDOWN(A1*2,0)/2

You could also use:

=FLOOR(A1,1/2)


In the above, substitute your formula for the calculated number for A1:

=ROUNDDOWN(your_formula*2,0)/2

=FLOOR(your_formula,1/2)

Then, format the cell as a fraction with one number; e.g: # ?/?
--ron