Round to nearest Quarter

[ahmedismailfourtex]

Hello,
Please advice, how to round a fraction to nearest quarter, for example:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Value[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1.1[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]1.2[/TD]
[TD]1.25[/TD]
[/TR]
[TR]
[TD]1.3[/TD]
[TD]1.25[/TD]
[/TR]
[TR]
[TD]1.4[/TD]
[TD]1.50[/TD]
[/TR]
[TR]
[TD]1.8[/TD]
[TD]1.75[/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance,

 

[steve the fish]

Try this:

=ROUND(A2*4,0)/4

 

[ahmedismailfourtex]

Perfect, appreciate your kind help