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 […]

# Formulas

## 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, […]

## Effective uses of MS Excel at workplace

MS Excel is one of the advanced tools for working with raw data, but people fear it too. The application seems complicated, and people think it as something that would take hours to figure out. This isn’t true at all. My students once asked me this question “Is there any possible way to make Microsoft […]