## If Functions with Three Conditions – Nested If Statement

The IF Function with single condition IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct…

Comments Off on If Functions with Three Conditions – Nested If Statement

## How to Find text in a range and return cell reference

Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value…

Comments Off on How to Find text in a range and return cell reference

## Nested If and Vlookup Function

If formula can be used together with VLookup formula to return an exact match of values and an empty string if the value not found. Combination of these formula makes…

Comments Off on Nested If and Vlookup Function

## Excel Formulas for Accounting and Finance

Excel spreadsheet is a common tool used by every accountant or financial analyst to analyze, report and share financial information. Some basic excel functions let you perform complex calculations and…

Comments Off on Excel Formulas for Accounting and Finance

## 10 Useful Examples of Macros for Beginners

What are Macros? They are a series of commands used to automate a repeated task. This can be run whenever the task must be performed. How to access Macros Click…

Comments Off on 10 Useful Examples of Macros for Beginners

## 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

## How To Make A Line Graph On Excel 2016

In this tutorial, we will be discussing how to create a basic line graph on Microsoft Excel 2016. Line graphs are generally used to show trends of a series of…

Comments Off on How To Make A Line Graph On Excel 2016

## VLOOKUP Parameters Explained in Detail with Example

VLOOKUP is one of the most useful Excel function. The function is used to search for specific value defined and returns the match in value from another column. The VLOOKUP…

Comments Off on VLOOKUP Parameters Explained in Detail with Example

## Excel Vlookup Multiple Criteria

There are various methods of returning a value from a Table array based on more than one criteria. Vlookup is used when there is only one criterion (condition). In this…

Comments Off on Excel Vlookup Multiple Criteria