COUNT function only counts the cells that contain numbers in a selected range. It will not count cells that have anything other than numbers. This function doesn’t count cells containing any text including error values and empty text (“”). In other words, if you want to count cells that contain text and numbers, you can […]

# infographics

## How to Use COUNTA Function in Excel – Infographics

COUNTA function counts the number of non-empty cells in a selected range. It will count cells that have numbers and/or any other characters in them. This function counts cells containing any type of data in a cell, including error values and empty text (“”). For example, if the range contains a formula that returns an […]

## How to Use OR Function in Excel – Infographics

Just like the IF function that we learned in our previous article “10-basic-excel-functions-everyone-know”, OR function is a logical function in Excel. This function is used for logical comparison within an IF function. In OR function, out of all comparisons, only one of the comparisons will be TRUE to return a result of TRUE. Syntax for […]

## How to Use Not Function in Excel – Infographics

The NOT function has only one argument. It can be used on its own also, but it is usually used along with IF function. Normally the logical functions return TRUE if the matched argument is true and FALSE if the matched argument is false. But NOT function gives FALSE if the matched argument is true, […]

## How to Use TRIM Function in Excel – Infographics

TRIM function is useful for removing extra spaces in a cell whether at beginning, trailing or anywhere between the words. Often when you pull data from a database you may find some extra spaces are put in behind or in front of legitimate data. This can create huge discrepancies. Especially when you are trying to […]

## How to use PROPER Function in Excel – Infographics

You can use the PROPER function to change the text from lower case or upper case to Proper case. In other words, using the PROPER Function you can change your text in the cell into starting alphabet as capital and all the rest into small. For example, if you have your text in abc or […]