The Excel ISERROR function lets you check if the formula resulted in an error. It returns TRUE or FALSE as output: For example, suppose you are preparing a Christmas Bonus …

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 …