Guides & Tutorials

The Excel TYPE function lets you check the data type of the given value. It returns an integer value corresponding to the type of the given value. For example, suppose …

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 …