The Excel BYCOL function lets you perform column-wise calculations using a custom LAMBDA function. It returns one result per column. For example, suppose that you are a Sales Manager. You …

The Excel IFNA function lets you display a custom (user-friendly) message if the formula returns a #N/A error. Such an error is common when the formula cannot identify or find …

The Excel SCAN function lets you perform cumulative operations over a list of values. It is mainly used to apply a custom LAMBDA calculation to each element of the given …

The Excel LET function lets you define named variables within a formula. It is mostly used within complex and lengthy formulas to assign names to values or calculations. Its main …

The Excel FALSE function returns the logical value FALSE. It is a compatibility function for legacy support. Nearly all logical functions in Excel return either TRUE or FALSE as the …

The Excel TRUE function returns the logical value TRUE. It is a compatibility function for legacy support. Most of the logical functions in Excel return either TRUE or FALSE as …

The Excel REDUCE function applies a custom LAMBDA function to each element of the given array and returns a single accumulated value. It is mostly used to calculate conditional sums …

The Excel IFERROR function lets you return a custom value (a blank cell or a text value) if the given formula generates an error. For example, suppose that your task …

The Excel SWITCH function allows you to compare an expression (or a value) to a list of possible values. You can define the desired result for each value. If the …

The Excel IF function lets you perform a logical test and display a desired value. You can display one value if the condition is true or another value if the …