Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Logical
Make decisions in formulas: IF, IFS, AND, OR, SWITCH, LET and LAMBDA. · 30 exercises
19 functions
ANDTRUE if all are trueBYCOLApplies a LAMBDA to each columnBYROWApplies a LAMBDA to each rowFALSEThe value FALSEIFOne value if true, another if falseIFERRORReplaces errorsIFNAReplaces #N/AIFSFirst value whose test is trueLAMBDAMakes your own functionLETNames values inside a formulaMAKEARRAYBuilds an array with a LAMBDAMAPApplies a LAMBDA to each valueNOTReverses TRUE and FALSEORTRUE if any is trueREDUCEReduces an array to one valueSCANRunning results of a LAMBDASWITCHMatches a value against a listTRUEThe value TRUEXORTRUE if an odd number are true