Rounding to nearest .50

1

Can the =Round function give an answer to the nearest .5?

So a result of 12.65, rounded down to 12.50

Answer
Discuss

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

Discuss

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
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login