## 'OR function' category

How to track sector performance in the stock market – Excel template

The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]

The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]

If cell equals value from list

This article demonstrates formulas that check if a cell value is equal to any value in a given list. Table […]

This article demonstrates formulas that check if a cell value is equal to any value in a given list. Table […]

If cell contains text from list

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

This article demonstrates several techniques to check if a cell contains text based on a list. The first example shows […]

IF with OR function

This article shows examples of how to use the IF function with the OR function. Table of Contents IF with […]

This article shows examples of how to use the IF function with the OR function. Table of Contents IF with […]

How to use the OR function

What is the OR function? The OR function allows you to carry out a logical test in eachÂ argument and if […]

What is the OR function? The OR function allows you to carry out a logical test in eachÂ argument and if […]

How to use Excel Tables

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

Excel calendar

Table of Contents Excel monthly calendar - VBA Â Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

Table of Contents Excel monthly calendar - VBA Â Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

Vlookup a cell range and return multiple values

VLOOKUP a multi-column range and return multiple values.

VLOOKUP a multi-column range and return multiple values.

Automate net asset value (NAV) calculation on your stock portfolio

Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

Table of Contents Automate net asset value (NAV) calculation on your stock portfolio Calculate your stock portfolio performance with Net […]

Search for a text string in a data set and return multiple records

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]