Excel Templates

Download our free Excel templates.

IF Statement Between Two Numbers

How to combine IF with AND functions In Excel, you can can combine IF with AND functions to return a value based on two different numbers.  This can be very useful when performing financial modeling and you are creating conditional situations. For example, if you are looking for a formula that will go into to cell B2 and, if...

Index Match Formula (Excel)

What is INDEX MATCH? The INDEX MATCH MATCH function is the combination of two formulas in Excel: INDEX and MATCH. =INDEX() returns the value of a cell in a table based on the column and row number. =MATCH() returns the position of a cell in a row or column. Combined the two formulas can look...

Countif Multiple Criteria (Excel)

How to countif multiple criteria? The Excel formula to countif multiple criteria is =countifs(). The “s” on the end makes it plural and therefore implies that there are multiple criteria (2 or more). In the examples and illustrations below this tutorial will show you exactly how to use countifs in Excel.   How to use countifs...

All Excel Templates A-Z