SheetFX
≡
<< Go back to all functions

CEILING.MATH

The CEILING.MATH function in Google Sheets rounds a number up to the nearest integer multiple of the specified significance, with negative numbers rounding toward or away from 0 depending on the mode. This function is useful in various scenarios, such as financial calculations, data analysis, and project management.

Function Syntax and Parameters

Syntax: CEILING.MATH(number, [significance], [mode])

Parameters:

  • number: The number you want to round.
  • significance: [Optional] The multiple to which you want to round.
  • mode: [Optional] The mode to use for rounding. The default mode is 0.

Step-by-Step Tutorial

  1. Using CEILING.MATH with a specified number and significance value:

    • Example: =CEILING.MATH(7.2, 0.5)
    • Result: 7.5

  2. Using CEILING.MATH with a negative number and mode set to "away from zero":

    • Example: =CEILING.MATH(-7.2, 0.5, 1)
    • Result: -7.5

Use Cases and Scenarios

  1. Financial Calculations: Round purchase prices or interest rates based on specific rounding rules.
  2. Data Analysis: Round values to a specific precision for statistical analysis or charting purposes.
  3. Project Management: Round time estimates or resource quantities to the nearest suitable unit.

Related Functions

  • FLOOR.MATH: Rounds a number down to the nearest integer multiple of specified significance.
  • ROUND: Rounds a number to a specified number of decimal places or digits.

Related Articles