How to use Logical AND, OR and IF Functions in Excel

The IF function is used to perform logical test and return one value if the condition is TRUE and another for FALSE results. Combining AND, OR and IF function varies…

Comments Off on How to use Logical AND, OR and IF Functions in Excel

How to use COUNTIF function with multiple criteria

COUNTIF function is one of the most common excel function used for counting numbers within a specific range. The number of cells in the range should match the supplied criteria.…

Comments Off on How to use COUNTIF function with multiple criteria