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
Related formulas 
Excel formula: Round a number up to nearest multiple
Round a number up to nearest multiple
If you need to round a number up to the nearest specified multiple (i.e. round a number up to the nearest dollar, up to the nearest $.25, up to the nearest multiple of 5, etc.) you can use the CEILING function. In the example, the formula in cell D6...
Related functions 
Excel CEILING function
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.

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.

500 Formula Examples, thoughtfully explained.