The Excel ISBLANK function lets you check if the cell is empty or not. It returns TRUE or FALSE as the output. For example, you can identify the students who …
The Excel MAKEARRAY function lets you generate a calculated array of a specified size using a LAMBDA function. Users have full control over the values in the array. They decide …
The Excel BYROW function lets you perform row-wise calculations using a custom LAMBDA function. It returns one result per row. For example, suppose that you are a Sales Manager. You …
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 …