Struct MaxFn 

pub struct MaxFn;

Trait Implementations

impl Debug for MaxFn

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Function for MaxFn

Returns the largest numeric value from one or more arguments.

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

title: "Maximum in a numeric range"
grid:
  A1: 5
  A2: 9
  A3: 1
formula: "=MAX(A1:A3)"
expected: 9

title: "Scalar text can be coerced"
formula: "=MAX(2, \"11\", 4)"
expected: 11

title: "No numeric values returns zero"
formula: "=MAX(\"x\")"
expected: 0

related:
  - MIN
  - LARGE
  - SMALL
  - MAXIFS
faq:
  - q: "Why can MAX return 0 for non-numeric input sets?"
    a: "When no numeric values are found, MAX returns 0 by design."
  - q: "Does MAX evaluate scalar text arguments?"
    a: "Yes, but only when scalar text can be coerced to a numeric value."

[formualizer-docgen:schema:start] Name: MAX Type: MaxFn Min args: 1 Max args: variadic Variadic: true Signature: MAX(arg1…: number@range) Arg schema: arg1{kinds=number,required=true,shape=range,by_ref=false,coercion=NumberLenientText,max=None,repeating=None,default=false} Caps: PURE, REDUCTION, NUMERIC_ONLY [formualizer-docgen:schema:end]

fn caps(&self) -> FnCaps

Capability flags for this function

fn name(&self) -> &'static str

fn min_args(&self) -> usize

fn variadic(&self) -> bool

fn arg_schema(&self) -> &'static [ArgSchema]

fn eval<'a, 'b, 'c>( &self, args: &'c [ArgumentHandle<'a, 'b>], _ctx: &dyn FunctionContext<'b>, ) -> Result<CalcValue<'b>, ExcelError>

The unified evaluation path.

fn namespace(&self) -> &'static str

fn volatile(&self) -> bool

fn aliases(&self) -> &'static [&'static str]

Optional list of additional alias names (case-insensitive) that should resolve to this function. Default: empty slice. Implementors can override to expose legacy names. Returned slice must have ’static lifetime (typically a static array reference).

fn function_salt(&self) -> u64

fn eval_reference<'a, 'b, 'c>( &self, _args: &'c [ArgumentHandle<'a, 'b>], _ctx: &dyn FunctionContext<'b>, ) -> Option<Result<ReferenceType, ExcelError>>

Optional reference result path. Only called by the interpreter/engine when the callsite expects a reference (e.g., range combinators, by-ref argument positions, or spill sources).

fn dispatch<'a, 'b, 'c>( &self, args: &'c [ArgumentHandle<'a, 'b>], ctx: &dyn FunctionContext<'b>, ) -> Result<CalcValue<'b>, ExcelError>

Dispatch to the unified evaluation path with automatic argument validation.