Data Analysis in Excel
Nick Edwards
Analyst at Mynd
Syntax for IF()
IF(logical test, [value if true], [value if false])
Syntax for a nested IF()
IF(logical test, [value if true],
IF(logical test, [value if true],
..., [value if false]))
Syntax for IFS()
IFS(logical test 1, [value if true 1],[logical test 2], [value if true 2]...)
IF()
s together[value if false]
#N/A
if none of the tests are trueSyntax for SWITCH()
SWITCH(expression, value 1, result 1, [default or value 2],[result 2],...)
Syntax for SWITCH()
SWITCH(expression, value 1, result 1, [default or value 2],[result 2],...)
Example: SWITCH the value in cell C1 based on the corresponding list:
Answer: SWITCH(C1,0,FALSE,1,TRUE)
Value | Result |
---|---|
0 | FALSE |
1 | TRUE |
Syntax for SWITCH()
SWITCH(expression, value 1, result 1, [default or value 2],[result 2],...)
Example: SWITCH the result in 2 - 1
to TRUE
if it equals 1
, and FALSE
if it equals 0 or 2.
Value | Result |
---|---|
0 | BLUE |
1 | GREEN |
2 | RED |
Answer: SWITCH(2-1,0,"BLUE",1,"GREEN",2,"RED")
--> 2-1
= 1
--> Green
Syntax for COUNTIF()
`COUNTIF(range, criteria)`
Syntax for COUNTIFS()
`COUNTIFS(range 1, criteria 1, [range 2], [criteria 2])`
TRUE
Data Analysis in Excel