Excel 2000 rounding
Posted by Gary Tovey on September 25, 2001 12:32 PM
I need a method of rounding similar to the MROUND function, but will only round up. I need to be able to specify the interval. For example, round up to the next 20 increment, 123 rounds to 140. Thank you in advance for any assistance.
Posted by IML on September 25, 2001 12:33 PM
=CEILING(123,20) (nt)
