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

HLOOKUP

Explanation HLOOKUP  is a powerful Excel function used to search for a value in a table or a range by matching it with data in a row. HLOOKUP is very…

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

TOCOL

Explanation TOCOL takes a range/array and converts it into a single column. Example Syntax =TOCOL(array, [ignore], [scan_by_column]) array - The range/array of cells we want to convert into a single…

0 Comments

End of content

No more pages to load