Need help on ROUND function in excel

[Cade]

I am trying to make a students report so i require some sort of help in ths matter. I would like to make a report which should be such that
i want the number 0.25 to be 0 only
i want the number 0.5 to be the same number 0.5
i want the numer 0.75 to be 1
So explain me a how can i use the round function with this condition in excel 2003. Any help would be appreciated.

[kattman]

The round function is a very useful in ms excel in rounding off the data to the neares round figure. Use the below code for the student report

=IF(A1=0.5,0.5,ROUND(A1,0))

If A1 = 0.5, you'll get 0.5 Else the ROUND() function does what it's supposed to do.

I hope that this eill solve the problem.

[Cade]

thank for helping me
i have already used this function before
the problem here is that the number can be 6.5 or 7.5 or 99.5 for example not only 0.5 . Please tell me what can i do say for example 9.5 and not 0.5 or any number i mean to say that for student reports it can be any (mark.5) (X.5)=(X.5)
So please provide me a solution with proper code

[Glenny]

I think that you don't need a round function . You can try using the if function because the if function would be more flexible. Consider the if function below to resolve your problem

IF ( A1= X.5 IT WILL BE X.5 , IF (A1 = X.25 IT WILL RETURN X.25+0.25) SO X.25 WILL B2 X.5 and you need X.75

So use this logic and you will get the solution.

[ThoMas321]

Hi,
I guess every one responding here are applying there own logics the formula suggested above is useful to some extent but is somewhat complicated to some extent. I have a different solution which is quite simpler than the above one.

If your value is in A1 use this formula:
=INT(A1)+IF(MOD(A1,1)<0.25,0,IF(MOD(A1,1)>0.75,1,0.5))

You can change the exact break points, as and when required, either by changing values or using >=0.75 etc.

[Cade]

I just wonder that why these formulaes are not working because when i use it when i type 5.25 its returning 5.5 This is TRUE
when i type 5.5 its returning 5.5 This is TRUE
when i type 5.75 its returning 5.5 This is False because i want it to return 6
i have still not got the desired solution So any help in this matter would be appreciated.