Excel Function

CEILING

Rounds number up to nearest multiple.

CEILING(number, significance)

Arguments

number

Required

Specify a single cell reference.

significance

Required

Enter a numeric value.

Practice Preview

display numeric calculation results. Use CEILING to Rounds number up to nearest multiple. use 10 for significance. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=CEILING(D2, 10)

Practice This Function

Practice in Sequential Mode Back to Function List