Excel CEILING Function
The Excel CEILING function returns a given number rounded up to a specified multiple. For example, =CEILING(A1,5) could be used to round a price in A1 to the nearest 5 dollars. CEILING always rounds up. The Excel FLOOR function rounds a given number down to the nearest specified multiple. FLOOR works like the MROUND function, … Read more