January 19, 2021

## ROWS function in Excel

In this lesson we will learn how the ROWS function works in Excel. We use ROWS function to count the number of rows in a …

## COUNTBLANK function in Excel

In this lesson we will learn how the COUNTBLANK function works in Excel. The COUNTBLANK function is used to count the number of blank cells …

## TRUE function in Excel

In this lesson we will learn how the TRUE function works in Excel. The TRUE function doesn’t take any input arguments and it returns the …

## IF function in Excel

In this lesson we will learn how the IF function can be used in Excel. The IF function evaluates a condition and returns respective value …

## OR function in Excel

In this lesson we will learn how the OR function works in Excel. The OR function is used when you want to check multiple conditions. …

## FALSE function in Excel

In this lesson we will learn how the FALSE function works in Excel. The FALSE function doesn’t take any input arguments and returns the logical …

## SUBSTITUTE function in Excel

In this lesson we will learn how the SUBSTITUTE function works in Excel. SUBSTITUTE function is used when you want to substitute text with new …

## LEN function in Excel

In this lesson we will learn how to use LEN function in Excel. LEN function is used when you want to get the total number …

## LOOKUP function in Excel

In this lesson we will learn how LOOKUP function works in Excel. The LOOKUP function finds the approximate match of a lookup value in a …

## AND function in Excel

In this lesson we will learn how the AND function works in Excel. AND function is used when you want to check multiple conditions. It …