Excel functions · 20 functions
Excel logical functions
Functions that test conditions and decide based on the result: IF to pick one of two outcomes, AND / OR to combine tests, IFERROR to catch errors.
Functions explained in full
- ANDTRUE if all conditions are true.
- IFReturns one value if a condition is true and another if false.
- IFERRORReturns a fallback if the value is an error.
- IFNAReturns a fallback if the value is #N/A.
- IFSReturns the value of the first true condition.
- NOTReverses a logical value.
- ORTRUE if any condition is true.
- SWITCHReturns the result for the first matching value.
All functions
TRUE if all conditions are true.
=AND(logical1, [logical2], ...)Returns one value if a condition is true and another if false.
=IF(logical_test, [value_if_true], [value_if_false])Returns a fallback if the value is an error.
=IFERROR(value, value_if_error)Returns a fallback if the value is #N/A.
=IFNA(value, value_if_na)Returns the value of the first true condition.
=IFS(logical_test1, value1, ...)Reverses a logical value.
=NOT(logical)TRUE if any condition is true.
=OR(logical1, [logical2], ...)Returns the result for the first matching value.
=SWITCH(expression, value1, result1, ..., [default])- BYCOL
Applies a LAMBDA to each column.
=BYCOL(array, lambda) - BYROW
Applies a LAMBDA to each row.
=BYROW(array, lambda) - FALSEYANLIŞ
The logical value FALSE.
=FALSE() - ISOMITTEDATLANMIŞ
TRUE if a LAMBDA argument was omitted.
=ISOMITTED(argument) - LAMBDA
Defines a custom function; pass it to MAP, REDUCE… or call it: LAMBDA(x,x*2)(5).
=LAMBDA([parameter1], ..., calculation) - LET
Assigns names to intermediate results.
=LET(name1, name_value1, [name2, name_value2], ..., calculation) - MAKEARRAYDİZİOLUŞTUR
Builds an array from LAMBDA(row,column).
=MAKEARRAY(rows, columns, lambda) - MAP
Applies a LAMBDA to each element of arrays.
=MAP(array1, [array2], ..., lambda) - REDUCE
Reduces an array to a value with LAMBDA(accumulator,value).
=REDUCE([initial_value], array, lambda) - SCAN
Like REDUCE but returns every intermediate value.
=SCAN([initial_value], array, lambda) - TRUEDOĞRU
The logical value TRUE.
=TRUE() - XORÖZELVEYA
TRUE if an odd number of conditions are true.
=XOR(logical1, [logical2], ...)
Stop memorising formulas. Describe them.
Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.
Try it free