## HLOOKUP Formula in Excel

How to Use the HLOOKUP Formula in Excel The HLOOKUP formula in Excel is used when you have a specific item you’d like to lookup in a table and there is only one of that item in the table i.e. it is unique and you want to reference something that exists within a...

## PRESENT VALUE (PV) Formula in Excel

How to Use the PRESENT VALUE (PV) Formula in Excel The PV formula in Excel is used to calculates the present value of a loan or investment based on a constant interest rate. This is often used to calculate the present value of future cash flows in a specific project...

## NPV VS IRR Formula in Excel

Know more about NPV VS IRR Formula in Excel Conflict between NPV and IRR NPV VS IRR Formula in Excel will provide the same indicator of the decision of accept or rejection of the project. However, NPV and IRR may provide conflicting results while comparing two or more...

## FUTURE VALUE (FV) Formula in Excel

How to Use the FUTURE VALUE (FV) Formula in Excel FUTURE VALUE (FV) Formula in Excel calculates the future value of an investment based on a constant interest rate and takes into consideration compounding of interest. Formula: Formula Explanation: Rate (required): The...

## EFFECT Formula in Excel

How to Use the EFFECT Formula in Excel The Effect formula in Excel returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. The effective annual interest rate is the interest rate that is earned...