Tuesday, November 5

CEILING Function in Excel.

The CEILING Function Rounds a Number Up to its Nearest Multiple of Significance. CEILING Function helps to round up the numbers as per the requirement.

Syntax:

=CEILING(Number,Significance)

Arguments:

  1. Number: The value that you want to Round Up.
  2. Significance: The Multiple that you want to Round Up.

See the Examples in blow Image.

Leave a Reply

Your email address will not be published. Required fields are marked *