Struct SwitchFn 

pub struct SwitchFn;

Returns the result corresponding to the first matching candidate value.

SWITCH(expression, value1, result1, [value2, result2], ..., [default]) compares expression against each candidate from left to right.

Remarks

• Matching is case-insensitive for text values.
• Numeric comparisons treat Int and Number values as compatible.
• A trailing unmatched argument acts as the default result.
• When no candidate matches and no default is supplied, returns #N/A.
• Errors in expression propagate immediately.

Examples

=SWITCH("gold","silver",1,"gold",2,0)

title: "Match a text label"
formula: '=SWITCH("gold","silver",1,"gold",2,0)'
expected: 2

title: "Fall back to default"
formula: '=SWITCH(3,1,"one",2,"two","other")'
expected: "other"

related:
  - IF
  - IFS
  - CHOOSE
faq:
  - q: "Does SWITCH compare text case-sensitively?"
    a: "No. Text comparisons are case-insensitive in this implementation."
  - q: "What happens when nothing matches?"
    a: "SWITCH returns the trailing default when provided; otherwise it returns #N/A."

[formualizer-docgen:schema:start] Name: SWITCH Type: SwitchFn Min args: 3 Max args: variadic Variadic: true Signature: SWITCH(arg1: any@scalar, arg2…: any@scalar) Arg schema: arg1{kinds=any,required=true,shape=scalar,by_ref=false,coercion=None,max=None,repeating=None,default=false}; arg2{kinds=any,required=true,shape=scalar,by_ref=false,coercion=None,max=None,repeating=None,default=false} Caps: PURE, SHORT_CIRCUIT [formualizer-docgen:schema:end]

Trait Implementations

impl Debug for SwitchFn

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

Formats the value using the given formatter.

impl Function for SwitchFn

[formualizer-docgen:schema:start] Name: SWITCH Type: SwitchFn Min args: 3 Max args: variadic Variadic: true Signature: SWITCH(arg1…: any@scalar) Arg schema: arg1{kinds=any,required=true,shape=scalar,by_ref=false,coercion=None,max=None,repeating=None,default=false} Caps: PURE, SHORT_CIRCUIT [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 dependency_contract( &self, _arity: usize, ) -> Option<FunctionDependencyContract>

Optional dependency contract for passive planning/FormulaPlane analysis.

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.