PPMT & IPMT

Function Explained PPMT and IPMT are both financial functions that can help us find the Principal and Interest amount of a certain payment.  PPMT function helps to calculate the Principal…

0 Comments

PMT

Function Explained PMT function is used to calculate the amount to be paid in each period on a loan or other financial instrument, such as bonds. Syntax =PMT(rate,nper,pv,[fv],[type]) rate -…

0 Comments

SEQUENCE

SEQUENCE Function Explained SEQUENCE function creates an array of sequential values. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user…

0 Comments

RANDARRAY

Explanation RANDARRAY is a function that generates an array of random numbers. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the…

0 Comments

FILTER

FILTER Function Explained FILTER returns a filtered list of values from a range that meet a certain criteria. It is part of the Excel Dynamic Array Formulas. This is a…

0 Comments

SORTBY

SORTBY Function Explained SORTBY function is used for dynamically sorting excel ranges by the values of other ranges. It is part of the Excel Dynamic Array Formulas. This is a…

0 Comments

SORT

SORT Function Explanation Sort function allows the user to dynamically sort ranges. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the…

0 Comments

UNIQUE

UNIQUE Function Explanation UNIQUE returns unique values from a range. It is part of the Excel Dynamic Array Formulas. This is a group of formulas which allows the user to…

0 Comments

Excel Wildcards

Explanation Excel wildcards can be used to replace any character in Excel and allow the user to perform advanced searches and partial matching. There are two wildcards in Excel: ?…

0 Comments

SUMPRODUCT

Explanation SUMPRODUCT Excel function returns the sum of the products of two or more arrays. Example: Array a: (a1, a2, a3) Array b: (b1, b2, b3) SUMPRODUCT(Array a, Array b)…

0 Comments

End of content

No more pages to load