Last 3 digit Round up or Round down

[sambit]

Hi,
How to make Last 3 digit Round up or Round down.

pl find attached excel file.

 

[Nebu]

Hi:
Please find the attached...

 

[sambit]

Hi Nebu,
Thank you very much.

 

[sambit]

Hi Nebu,
you create a helping coloum. can u make solve the issue without helping coloum.

 

[Nebu]

you can do it by hard coding the numbers into the formula!!
But it is much easier with a helper column, if you have more than 3 criteria.
However, if it is only 250, 450, 850, it can be hard coded let me know.....

 

[Hui]

Have you tried: =ROUND(E5,-2)

 

[sambit]

Hui Sir,
Great!!!!!!!!!!!!!