MS Excel provides you with multiple options to round off numbers based on the final value required. If you require rounding off a particular number to its nearest half, (i.e. from 1.0 to 1.5) you can use several options. Let us look at the variants of the Round() function that you can use in detail:

CEILING():

This function basically rounds off the number to the nearest multiple of the incremental value. The syntax of the function is '=CEILlNG(number, incremental_ value)'. Both the numbers should bear the same sign, i.e, either the numbers should be positive or both numbers should be negative. The function returns a '#NUM!' error value, if the signs of both numbers are different.

For example, '=CEILlNG(3.84,0.05)' will return 3.85 which is the nearest multiple of the incremental value.

ROUNDUP():

Like the name suggests, this function always rounds a number to its higher value. The syntax of the function is '=ROUNDUP(number, decimal_ digits)'. If you set the decimal_digits value to zero, the number will be rounded off to the nearest integer value. If you set the decimal_digits value which is greater than zero, the number will be rounded up to the number of decimal places specified. If you set the decimal_digits value which is less than zero, the number will be rounded off from the left, instead of the right of decimal point of the number.

MROUND():

The 'M' in the function name refers to multiple. The syntax of the function is '=MROUND(number, multiple_ number)'. Both the numbers should bear the same sign, i.e., either the numbers should be positive or both numbers should be negative.

The function returns a '#NUM!' error value, if the signs on both the numbers are different. For our issue at hand, we can use the three functions as follows:

Type the required number in column A.

The first and the easiest option you can use is '=CEILlNG(A1,0.5)'

You can also use the 'ROUNDUPO' function as '=ROUNDUP(A1*2,0) /2'

You can also use the 'MROUNDO' function as '=MROUND(A 1 +0.24999999,0.5)'.