Excel Forum
Similar Content
Make Negative Numbers Positive in Excel and Vice Versa
Tutorial: I will show you a few ways to change negative numbers to positive numbers and back again ...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...



Excel Magic Trick 380: Negative Numbers Round To Nearest 5


See that MROUND will not round to a multiple for negative numbers. Instead will see how to use the ROUND function to round to the nearest increment or multiple.





Got a Question? Ask it Here in the Forum.