MS Excel 2003 - Rounding up and down (nested IF) 1

[spartansFC]

Hi

I need to create a nested IF statement i think that rounds up or down to the nearest .5 based on certain criteria.

0-0.2499 round down to the nearest day
.25-.4999 round up to nearest half day
.5-.7499 round down to nearest half day
.75-.9999 round up to nearest day

for example

6.23 = 6 days
6.42 = 6.5 days
6.71 = 6.5 days
6.76 = 7 days

i did have

=IF(A1<0.23,ROUNDDOWN(A1,0.5),IF(A1<0.5,ROUNDUP(A1,0.5),ROUNDDOWN(A1,0)))

but the above doesn't seem to work properly. Anyone have any ideas

thanks

Mikie

 

[lionelhill]

multiply by 2, round conventionally, and divide by 2.

 

[combo]

What about the CEELING function?

=CEILING(A1,0.25)

combo

 

[combo]

Sorry, proper function name (as in the box): CEILING.

combo

 

[spartansFC]

thanks to everyone for you replies, i got it working by using lionelhill's method

=ROUND(J11*2,0)/2