How to use ROUND and MROUND
Requirement:
To round a result from a formula.
Example: =SUM(K16*1.03) with the result in L16. The user requires the result to round down to .00; if the result that will populate L16 ends in .05 to .09 the result will round up to .10.
Solution:
=ROUND(SUM(K16*1.03),1)
Requirement:
To round a result from a formula to the nearest 0.25.
Solution:
=MROUND(K16*1.03,0.25)
Obtained from the OzGrid Help Forum.
Solution provided by NBVC and 63falcondude.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to first average a range and then round the value |
| How to set rounding precision |
| How to use IFERROR, ROUND and SUM in one formula |
| How to round to nearest .25 (times) |
| How to use a macro to run through sheet in excel and put double quotes around values |
| How to create a macro to round total based on a cell value |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
