Microsoft Excel is a very useful application for working with formulas and calculation but sometime we want more control and access, so today’s topic is how to round off value which nearest to 0.5, here is the easy solution, this method will work with all version of MS Excel like 2003 to 2016, just follow these easy steps.
1. To round off a value which greater or lesser than 0.5, select the cell
2. Press “F2” to edit the formula insert “=Round(select column name+row number,0)” and hit “enter” the formula is “=round(,0)”