[]

Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
  - RADIANS
  - RAND
  - RANDARRAY
  - RANDBETWEEN
  - RANK
  - RANK.AVG
  - RANK.EQ
  - RATE
  - RECEIVED
  - REDUCE
  - REPLACE
  - REPLACEB
  - REPT
  - RIGHT
  - RIGHTB
  - ROMAN
  - ROUND
  - ROUNDDOWN
  - ROUNDUP
  - ROW
  - ROWS
  - RRI
  - RSQ
  - RTD
  - SCAN
  - SCATTERSPARKLINE
  - SEARCH
  - SEARCHB
  - SEC
  - SECH
  - SECOND
  - SERIESSUM
  - SEQUENCE
  - SHEET
  - SHEETS
  - SIGN
  - SIN
  - SINH
  - SINGLE
  - SKEW
  - SKEW.P
  - SLN
  - SLOPE
  - SMALL
  - SORT
  - SORTBY
  - SPREADSPARKLINE
  - SQRT
  - SQRTPI
  - STACKEDSPARKLINE
  - STANDARDIZE
  - STDEV
  - STDEV.P
  - STDEV.S
  - STDEVA
  - STDEVP
  - STDEVPA
  - STEYX
  - SUBSTITUTE
  - SUBTOTAL
  - SUM
  - SUMIF
  - SUMIFS
  - SUMPRODUCT
  - SUMSQ
  - SUMX2MY2
  - SUMX2PY2
  - SUMXMY2
  - SWITCH
  - SYD
- Functions T to Z

SWITCH

This function compares specified expression against given list of values and returns the result according to the first matching value.

Syntax

SWITCH(expression,value, result, result_no_match)

Arguments

This function has the following arguments:

Argument	Description
expression	Value or expression to compare
value	Value compared against expression
result	Value returned if comparision matches
result_no_match	Value returned if comparision do not match

Remarks

In this function, argument value and result can take upto 126 different entries each.

Data Types

Accepts data of any type. Returns data of any type.

Examples

SWITCH(WEEKDAY(A2),1,"Sunday",2,"Monday",3,"Tuesday","No match") gives the result No match.

Version Available

This function is available in Spread for Windows Forms 11.0 or later.