Multiple IF statements checking decimal values.- USED VLOOKUP INSTEAD OF NESTED IF

Hello everyone,

First post here, but hoping this question is quite easy. I am using Excel 2010.

I have number decimal values that I need to round, for example:

Anything below 1.07 needs to be rounded down to 1.0
Anything above 1.07 needs to be rounded up to 1.25

Anything below 4.22 needs to be rounded to 4.25
Anything above 6.22 needs to be rounded up to 6.50

Anything below 7.37 needs to be rounded to 7.50
Anything above 8.37 needs to be rounded up to 8.75

Anything below 4.52 needs to be rounded to 4.50
Anything above 4.52 needs to be rounded up to 6.00 decimal value.

Basically I am rounding based on some quarter rules that I have established.

The tricky thing is, I understand how to setup the rounding in the IF function, the only problem is I don't understand how I can target only to check to round based on the decimals?

Also the other issue is how to round the integer in the last example.

Does anyone have any help on this subject? I would very much appreciate it. I looked through the threads and I couldn't find something similar to this, I hope I didn't miss it.

Thanks so much

Joseph Rosenblatt