Formualizer Docs
ReferenceFunctionsMath Functions

BASE

BASE: Converts a non-negative integer to text in the requested radix.

Summary

Converts a non-negative integer to text in the requested radix.

Examples

Convert decimal to hexadecimal
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1F

FAQ

What bases are supported?

BASE accepts radix values from 2 through 36.

Runtime metadata

Category

Math

Signature

BASE(arg1: Number, arg2: Number, arg3…: Number)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

AVERAGEIFS

AVERAGEIFS: Returns the average of cells that satisfy multiple criteria.

CEILING

CEILING: Rounds a number up to the nearest multiple of a significance.

On this page

SummaryExamplesRelated functionsFAQWhat bases are supported?Runtime metadata