Round off numbers and remove decimal points

Hi All,

I need to round up a number based on a the decimal value it has...

round up 52.30 to 52
round up 52.49 to 52
round up 52.50 to 53
round up 52.78 to 53

that is: if the decimal is below .50 it should round off to integer. if it has a decimal greater than or equal to 0.50 then it should round off to next integer.

Finally that resulting number should be presented without decimal ( decimal should be removed)

Please provide me the solution to tackle this with formula.

Thanks for your time and consideration.

does the basic round function not work?

Formula:

Please Login or Register  to view this content.

=round(a1,0)

	a	b
1	52.3	52
2	52.49	52
3	52.5	53
4	52.78	53

Hi Alkey,

Working fine.... answer comes as 53.00
how this decimal .00 can be removed using formula...

Thanks for your time...

That is just formatting. This link should help explain how to change that:
http://searchengineland.com/easy-to-...n-excel-130203

@bmbalamurali Simply format cells as General.

Thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).