# Round a number up to next half

=CEILING(number,0.5)

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

## 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.