Formula to round numbers greater than or equal to 0.5 to the next whole number/less than to previou

Contributor

Hi All,

Hope you are doing well!... I am trying to round up numbers greater than or equal to 0.5 to 1 and then less than 0.5 to the previous whole number...Can you please let me know how to achieve the same.. Please find attached the file with the input column Data and the output column.. Can you please help me here..

Thanks,
Arun

2 Replies

@Arun Chandramouli 

=ROUND(A2,0)

Maybe with this formula. Is this what you want to do?

Hi Quadruple_Pawn ..I am getting the answer by doing MROUND(A2,1)