[]

Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
  - HARMEAN
  - HBARSPARKLINE
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - HISTOGRAMSPARKLINE
  - HLOOKUP
  - HOUR
  - HSTACK
  - HYPERLINK
  - HYPGEOM.DIST
  - HYPGEOMDIST
  - IF
  - IFERROR
  - IFNA
  - IFS
  - IMABS
  - IMAGE
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - INDEX
  - INDIRECT
  - INFO
  - INT
  - INTERCEPT
  - INTRATE
  - IPMT
  - IRR
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISO.CEILING
  - ISODD
  - ISOMITTED
  - ISOWEEKNUM
  - ISPMT
  - ISREF
  - ISTEXT
  - JIS
  - KURT
  - LAMBDA
  - LARGE
  - LCM
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LET
  - LINEST
  - LINESPARKLINE
  - LN
  - LOG
  - LOG10
  - LOGEST
  - LOGINV
  - LOGNORM.DIST
  - LOGNORM.INV
  - LOGNORMDIST
  - LOOKUP
  - LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z

IFS

This function performs a comparison and returns the specified associated value if comparision is TRUE.

Syntax

IFS(condition,value1, [condition2,value2],...)

Arguments

This function has the following arguments:

Argument	Description
condition1	Refers to a value or expression to evaluate.
value1	Refers to a value to return if the test evaluates to true.
[condition2,value2],...	[Optional] Refers to more conditions to be compared (nested IF statements).

Remarks

This function allows users to test upto 127 different conditions.

Data Types

Accepts numeric (boolean) data for both arguments. Returns any data type.

Examples

IFS(A2=89,"A",A2=79,"B") gives the result B.

Version Available

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