I refer you to post 3, what are your rules they are inconsistent. Everything else rounds up, but it goers down. what other values would go down?

I imagine you could get any decimal values, what about .12 or 0.14 do they go up or down? without you explaining the rules you will not get an answer that works

=IF(MOD(A1*4,1)=0,0.25,0)+CEILING(A1*4,1)/4 +if(mod(a1,1)=0.13,-0.25,0) works but this can not be the correct answer but fits your sample.