Skip to content

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

All functions

  • ANDVEFull page

    TRUE if all conditions are true.

    =AND(logical1, [logical2], ...)
  • IFEĞERFull page

    Returns one value if a condition is true and another if false.

    =IF(logical_test, [value_if_true], [value_if_false])
  • IFERROREĞERHATAFull page

    Returns a fallback if the value is an error.

    =IFERROR(value, value_if_error)
  • IFNAEĞERYOKSAFull page

    Returns a fallback if the value is #N/A.

    =IFNA(value, value_if_na)
  • IFSÇOKEĞERFull page

    Returns the value of the first true condition.

    =IFS(logical_test1, value1, ...)
  • NOTDEĞİLFull page

    Reverses a logical value.

    =NOT(logical)
  • ORYADAFull page

    TRUE if any condition is true.

    =OR(logical1, [logical2], ...)
  • SWITCHİLKEŞLEŞENFull page

    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], ...)

Excel functions →

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