Logical
Logical

IFERROR

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.

104 View Details
Logical
Logical

IFNA

Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression.

147 View Details
Logical
Logical

OR

Returns TRUE if any argument is TRUE.

160 View Details
Logical
Logical

NOT

Reverses the logic of its argument.

89 View Details
Logical
Logical

IFS

Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

146 View Details
Logical
Logical

AND

Returns TRUE if all its arguments are TRUE.

144 View Details
Logical
Logical

IF

Checks whether a condition is met, and returns one value if TRUE, and another if FALSE.

164 View Details
Logical
Logical

MAKEARRAY

Returns a calculated array of a specified row and column size, by applying a LAMBDA.

143 View Details
Logical
Logical

SCAN

Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.

200 View Details
Logical
Logical

REDUCE

Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.

165 View Details
Logical
Logical

MAP

Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA.

133 View Details
Logical
Logical

BYROW

Applies a LAMBDA to each row of an array and returns an array of the results.

71 View Details
Logical
Logical

BYCOL

Applies a LAMBDA to each column and returns an array of the results.

118 View Details
Logical
Logical

LAMBDA

Use to create custom, reusable functions and call them by a friendly name.

141 View Details
Logical
Logical

LET

Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula.

80 View Details
Logical
Logical

TRUE

DOĞRU isimli formül tanıtımımızda, DOĞRU Özelliğinin Kullanıldığı İçerikler, Diziliş Yapısı ve Desteklenen Excel Versiyo...

125 View Details
Logical
Logical

FALSE

YANLIŞ isimli formül tanıtımımızda, YANLIŞ Özelliğinin Kullanıldığı İçerikler, Diziliş Yapısı, açıklaması ve Desteklenen...

113 View Details
Logical
Logical

XOR

Returns a logical exclusive OR of all arguments.

111 View Details
Logical
Logical

SWITCH

Evaluates an expression against a list of values and returns the result corresponding to the first matching value.

94 View Details