Concatenate

CONCATENATE Function Explanation The CONCATENATE function in Excel allows us to merge text from multiple cells into one cell. This can be useful for creating a single, combined string of…

0 Comments

FORMULATEXT Function

FORMULATEXT Function Explanation The FORMULATEXT function in Excel allows us to display the formula of a cell as text. This can be useful for showing the underlying calculations of a…

0 Comments

Excel Mortgage Calculator

Below is a mortgage calculator which can be used to calculate the monthly payment, and see the payment schedule based on the data provided. Once the results are generated based…

0 Comments

FV

Function Explained FV function is used for the calculation of the Future Value of a loan or any other financial instrument. Example The bank agreed to give you a loan…

0 Comments

PV

Function Explained PV function is used for the calculation of the present value of a loan. Syntax The PV arguments are as follows: Rate – That’s our interest rate.  Nper…

0 Comments

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

HSTACK

Explanation HSTACK is a function that allows you to stack 2 or more arrays horizontally. An array could be a single cell, row, column, or any combination of rows and…

0 Comments

VSTACK

Explanation VSTACK is a function that allows you to stack 2 or more arrays vertically. An array could be a single cell, row, column, or any combination of rows and…

0 Comments

End of content

No more pages to load