Rounding formual

[haneefa]

Dear sir ,

kindly send formula to round as below

name net salary formula requried for below rounding

xx 200.020 200.025
x1 200.026 200.050
x2 200.051 200.075
x3 200.076 201.000

 

[barry houdini]

If the unrounded amount is in B2 try this formula in C2

=CEILING(B2,0.025)

 

[Jon von der Heyden]

Assuming the numbers begin in B1:

=-SUBSTITUTE(-CEILING(SUBSTITUTE(B1,".0","."),0.25),".",".0")

Copied down to end of range.