UNIQUE Function

UNIQUE Function

by | Feb 14, 2019

The Excel UNIQUE function is a lookup and reference formula that returns a list of unique values from a list or range. This formula is one of the newest Dynamic Array functions to be released with Excel 2019. In this guide, we’re going to show you how to use the Excel...
Function: INDEX

Function: INDEX

by | Feb 12, 2019

The Excel INDEX function returns a value or the reference of a value at a given position in a range or array. The INDEX function has two different forms to return a value or a reference. Using an array form returns a value, while a reference form returns a reference....
IFS Function in Excel

IFS Function in Excel

by | Feb 5, 2019

The IFS function in Excel is a really handy tool that makes it easier for you to check different conditions and get specific results based on those checks. It's like having a simpler way to ask multiple "if this, then that" questions within your spreadsheet....
Excel SWITCH Function

Excel SWITCH Function

by | Feb 5, 2019

The Excel SWITCH function evaluates the value in its first argument against the value-result pairs defined with them, and returns the matched pair if there is a match, and the default value if there isn't. The SWITCH function is a good alternative to the IF function...

How to use IFS and SWITCH formulas instead of nested IF statements

by | Jan 30, 2019

Nested IF statements are useful for creating more complicated scenarios in Excel. However, IFS and SWITCH formulas can work more efficiently when dealing with more than one condition. These formulas work a bit differently than the legacy IF function. Let’s start...
Function: MIRR

Function: MIRR

by | Jan 30, 2019

The MIRR Excel function is a finance function that calculates the modified internal rate of return (MIRR) for a series of periodic cash flows. This function works by using both the cost of the investment and the interest received by reinvesting the cash. In this...
Function: IRR in Excel

Function: IRR in Excel

by | Jan 30, 2019

The IRR Excel function is a crucial finance tool for calculating the internal rate of return (IRR) of periodic cash flows. It assumes that cash flows occur at regular intervals. In this guide, we'll demonstrate how to use the IRR Excel function effectively, including...
Function: XNPV

Function: XNPV

by | Jan 29, 2019

The XNPV function is a finance function which can calculate the net present value (NPV) of a series of non-periodic cash flows, based on a specified discount rate. In this guide, we’re going to show you how to use the XNPV function and also go over ome tips and error...