Can the =Round function give an answer to the nearest .5?
So a result of 12.65, rounded down to 12.50
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Rounding to nearest .50
1
Answers
1
Selected Answer
That would be the MROUND() function.
= MROUND(A3, 0.5)where A3 is the value to be rounded and 0.5 the rounding instruction. The rounding is done by 5/4 rule, meaning 5 = up, 4 = down. In practical terms, if A3 = 12.75 the function returns 13, if A3 = 12.74 the result will be 12.5
Discussion
Variatus, many thanks for taking the time to answer this for me, very much appreciated.
unonovo (rep: 6) Apr 30, '17 at 7:09 pm