Rounddown formula needed

[Bradley King]

I am needing a formula that will round down numbers to the
nearest .5

 

[Lance]

=ROUNDDOWN(C4*2,0)/2

 

[klswvu]

=MROUND(A1,0.5)
--Rounds to the nearest 0.5 up/down ie 1.74=1.5 while 1.75=2.0

=A1-(MOD(A1,0.5))
--Rounds to the lowest 0.5 ie 1.74=1.5 while 1.99=1.5

KLS

 

[dvt]

I am needing a formula that will round down numbers to the
nearest .5

=FLOOR(A1*2,1)/2

Dave
dvt at psu dot edu