`math ceil` for math

Returns the ceil of a number (smallest integer greater than or equal to that number).

Signature

> math ceil {flags} ...rest

Parameters

...rest: The cell-paths/columns to operate on.

Input/output types:

input	output
number	int
duration	duration
filesize	filesize
list<number>	list<int>
list<duration>	list<duration>
list<filesize>	list<filesize>
range	list<number>
record	record

Examples

Apply the ceil function to a list of numbers.

> [1.5 2.3 -3.1] | math ceil
╭───┬────╮
│ 0 │  2 │
│ 1 │  3 │
│ 2 │ -3 │
╰───┴────╯

Apply ceiling to list-valued columns in a record.

> {alice: [1.2 2.7 3.5], bob: [4.1 5.9]} | math ceil
╭───────┬───────────╮
│       │ ╭───┬───╮ │
│ alice │ │ 0 │ 2 │ │
│       │ │ 1 │ 3 │ │
│       │ │ 2 │ 4 │ │
│       │ ╰───┴───╯ │
│       │ ╭───┬───╮ │
│ bob   │ │ 0 │ 5 │ │
│       │ │ 1 │ 6 │ │
│       │ ╰───┴───╯ │
╰───────┴───────────╯

Apply ceiling to a single column using a cell path.

> {alice: [1.2 2.7 3.5], bob: [4.1 5.9]} | math ceil alice
╭───────┬──────────────╮
│       │ ╭───┬───╮    │
│ alice │ │ 0 │ 2 │    │
│       │ │ 1 │ 3 │    │
│       │ │ 2 │ 4 │    │
│       │ ╰───┴───╯    │
│       │ ╭───┬──────╮ │
│ bob   │ │ 0 │ 4.10 │ │
│       │ │ 1 │ 5.90 │ │
│       │ ╰───┴──────╯ │
╰───────┴──────────────╯

Filesize values are already whole bytes, so ceiling is a no-op.

> 2.1KB | math ceil
2.1 kB

Notes