MrExcel Publishing
Your One Stop for Excel Tips & Solutions

MROUND


Posted by joey on September 12, 2001 3:50 PM

I am trying to use mround to round a value up to then next multiple of 10. The problem I am having is that it rounds to the nearest multiple. Any ideas on how to get it to round up?


Posted by joey on September 12, 2001 3:51 PM

I am trying to use MROUND to round a value up to the next multiple of 10. The problem I am having is that it rounds to the nearest multiple of 10 which is sometimes down. Any ideas on how to get it to round up?

Posted by IML on September 12, 2001 4:03 PM

Try =CEILING(your value,10)