How to round up to 0.25, 0.5, 0.75, 0.95

[Ahmed2018]

Hi

Hope you fine all ,

How to round up to 0.25, 0.5, 0.75, 0.95 EXCEPT the Whole number to ( same number - 0.05 )

for ex.

10.22 = 10.25
10.33 = 10.5
10.66 = 10.75
10.82 = 10.95
10 ( Whole number ) = 9.95

Thanks in advanced

[Keebellah]

Hi Ahmedn,

Use the Function ROUNDUP()

[kvsrinivasamurthy]

Try this. In B2 then drag down.

=IF(A2="","",IF(MOD(CEILING(A2,0.25),1)=0,CEILING(A2,0.25)-0.05,CEILING(A2,0.25)))

[jason.b75]

Another way

=IF(A2="","",INT(A2)+LOOKUP(MOD(A2,1),{0,0.01,0.26,0.51,0.76},{-0.05,0.25,0.5,0.75,0.95}))

[joeu2004]

How to round up to 0.25, 0.5, 0.75, 0.95 EXCEPT the Whole number to ( same number - 0.05 )

Are you sure? So you want the following:

10.01 -> 10.25?
10.26 -> 10.50?
10.51 -> 10.75?
10.76 -> 10.95?

What about 10.004, which only appears to be 10.00 if the cell format displays 2 decimal places: 9.95 or 10.25?

Or do your original numbers (before rounding up) already have only 1 or 2 decimal places, either because they are entered that way, or because the calculation is explicitly rounded (not just relying on cell formatting, unless you have set "Precision as displayed")?