Hi Guys,

I need a help for the below problems that i am facing.

I need one formula or equation to fulfill the below equation.

1. if the last two decimal is 0.0 will remain us zero
2. if last two decimal is 0.01 - 0.49 , it will be round up to 0.50
3. if last two decimal is 0.51 - 0.89 , it will be round up to 0.90
4. if last two decimal is 0.91 - 0.99 , it will be round up to the nearest dollar


Thanks in advance for the effort in helping me solve this big problem of mine.

Best Regards,
Winston