SheetFX
≡
<< Go back to all functions

CEILING

The CEILING function in Google Sheets rounds a number up to the nearest integer multiple of a specified significance. This function is useful when you need to round numbers up to specific increments. Discover how to utilize this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: CEILING(value, [factor])

Parameters:

  • value: The number you want to round up.
  • factor (optional): The significance to which you want to round up the value (default is 1).

Step-by-Step Tutorial

  1. Using CEILING with a single number:

    • Example: =CEILING(7.3)
    • Result: 8

  2. Using CEILING with a specified factor:

    • Example: =CEILING(12, 5)
    • Result: 15

Use Cases and Scenarios

  1. Pricing Strategy: Round up product prices to specific increments.
  2. Time Management: Round up time values to the nearest 5 or 10-minute interval.
  3. Inventory Management: Round up inventory quantities to the nearest multiple of a specific value.

Related Functions

  • FLOOR: Round a number down to the nearest integer multiple of a specified significance.
  • ROUND: Round a number to a specified number of decimal places.

Related Articles