Formulas Excel Logica

IF Statement: =IF(logicaltest, [valueiftrue], [valueif_false])

AND Function: =AND(logical1, [logical2], …)

OR Function: =OR(logical1, [logical2], …)

NOT Function: =NOT(logical)

IFERROR Function: =IFERROR(value, valueiferror)

IFNA Function: =IFNA(value, valueifna)

XOR Function: =XOR(logical1, [logical2], …)

SWITCH Function: =SWITCH(expression, value1, result1, [value2], [result2], …)

CHOOSE Function: =CHOOSE(index_num, value1, [value2], …)

TRUE Function: =TRUE()

FALSE Function: =FALSE()