Exceljet

Quick, clean, and to the point

Round a number up to next half

Excel formula: Round a number up to next half
Generic formula 
=CEILING(number,0.5)
Explanation 

If you need to round a number up to the next half, you can use the CEILING function, which always rounds up based on a supplied multiple.

Note that MROUND also rounds based on a supplied multiple, but it always rounds to the nearest multiple.

In the example, the formula shown is:

=CEILING(B5,0.5)

Even though the value in B5 is 1.1, CEILING rounds up to the next multiple of .5, which is 1.5

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.