Function: XIRR
The XIRR function is a finance function that calculates the internal rate of return (IRR) of a series of non-periodic cash flows. This function works like the IRR function, but doesn't require entering regular intervals. In this guide, we’re going to show...
Function: IRR
The IRR Excel function is a finance function which can calculatee the internal rate of return (IRR) of a series of periodic cash flows. The function assumes that the cash flows occurs at regular intervals. In this guide, we’re going to show you how to use...
Function: XNPV
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...
Function: NPV
The Excel NPV function is a finance function that calculates the net present value (NPV) of a series of cash flows based on a specified discount rate. In this guide, we’re going to show you how to use the Excel NPV function and also go over some tips and error...
Function: EXACT
Excel EXACT function compares two strings and returns TRUE for a perfect match, and FALSE if not. Note that this comparison is case-sensitive. In this guide, we’re going to show you how to use Excel EXACT function to compare strings and also go over some tips and...
Function: IFERROR
The IFERROR function evaluates a formula and returns a specified value if the formula generates an error. Otherwise, the function returns the result of the formula. In this guide, we’re going to show you how to use the IFERROR function and also go over some tips and...
Function: TEXT
Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling methods....
Function: MROUND
The MROUND function rounds a number to the nearest multiple of a specified number. In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods. Supported versions All versions Syntax [box...
Function: ROUNDDOWN
The ROUNDDOWN function rounds down a number to a specified number of digits. In this guide, we’re going to show you how to use the ROUNDDOWN function and also throw in some tips and error handling methods. Supported versions All versions Syntax [box...