Forum Discussion
Arun Chandramouli
Mar 29, 2022Brass Contributor
Formula to round numbers greater than or equal to 0.5 to the next whole number/less than to previou
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
- OliverScheurichGold Contributor
- Arun ChandramouliBrass ContributorHi Quadruple_Pawn ..I am getting the answer by doing MROUND(A2,1)