Formualizer Docs
ReferenceFunctionsMath Functions

MAX

MAX: Returns the largest numeric value from one or more arguments.

Summary

MAX scans scalar values and ranges, considering only values that can be treated as numbers.

Remarks

  • Errors in any scalar argument or range cell propagate immediately.
  • In ranges, non-numeric cells are ignored.
  • Scalar text is included only when it can be coerced to a number.
  • If no numeric value is found, MAX returns 0.

Examples

Maximum in a numeric range
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
9
Scalar text can be coerced
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
11
No numeric values returns zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

Why can MAX return 0 for non-numeric input sets?

When no numeric values are found, MAX returns 0 by design.

Does MAX evaluate scalar text arguments?

Yes, but only when scalar text can be coerced to a numeric value.

Runtime metadata

Category

Math

Signature

MAX(arg1…: Number (Range))

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Number · Range · coercion NumberLenientText

Caps

PUREREDUCTIONNUMERIC_ONLY

Source

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

LOG10

LOG10: Returns the base-10 logarithm of a positive number.

MIN

MIN: Returns the smallest numeric value from one or more arguments.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can MAX return 0 for non-numeric input sets?Does MAX evaluate scalar text arguments?Runtime metadata