﻿---
author: Stefan-Stojanovic

type: normal

category: how to

links:
  - '[CEILING](https://support.google.com/docs/answer/3093471){documentation}'

---

# CEILING

---
## Content

The `=CEILING()` function is used to round a number up to a specified integer or decimal place.

The syntax is:
```plain-tex
=CEILING(value, factor)
```

The `value` is what we want to round down. You can manually input a number or select a cell.

The `factor` value is optional. It determines up to what decimal the `value` is rounded up. 

> 💡 The `factor` value is `1` by default and can never be `0`.

When the `value` is positive, the `factor` must be positive. 

When the `value` is negative, the `factor` can be either positive or negative.

![ceiling](https://img.enkipro.com/3ad58926a0e4b72d6897e9fa009f6345.png)

---
## Practice

The ??? function is used to round a number ??? to a specified integer or decimal place.

* CEILING()
* up
* FLOOR()
* down

---
## Revision

What would the output of this function be?

```plain-text
=CEILING(19.89)
```

???

- 20
- 19
- 21
- 19.9