Function: RATE

Function: RATE

The Excel RATE function is a Financial formula that calculates and returns the interest rate for a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error...
Function: FV

Function: FV

The FV Excel function is a Financial formula that calculates and returns the future value of a loan or an investment, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel FV function and also go over some tips and...
Function: PV

Function: PV

The Present Value Excel function (PV) is a Financial formula that calculates and returns the present value of a loan or an investment based on constant payments, and interest rate. In this guide, we’re going to show you how to use the Present Value Excel function (PV)...
Function: NPER

Function: NPER

The NPER function is a Financial formula that calculates and returns the number of repayment periods of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel NPER function and also go over some tips and error...
Function: PMT

Function: PMT

The PMT is a Financial function that calculates and returns the repayment amount of a loan based on constant payments and a constant interest rate. This formula is commonly used in amortization schedule Excel models. In this guide, we’re going to show you how to use...
Function: ABS

Function: ABS

The ABS function is a Math formula that returns the absolute value of a given number. The absolute value of a number represents number’s distance from zero, regardless of the direction. This means that the distance of a number x has the same distance as negative...
Function: LOG10

Function: LOG10

The LOG10 Excel function is a Math formula that returns the logarithm of a given number, using base 10. The logarithm of a given number is the exponent to which another fixed number (the base 10) must be raised to produce that number. In this guide, we’re going to...
Function: LOG

Function: LOG

The Excel LOG function is a Math formula that returns the logarithm of a given number and base. In this guide, we’re going to show you how to use the LOG function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel LOG...
Function: LN

Function: LN

The Excel LN function is a Math formula that returns the natural logarithm of a given number. The natural logarithm of a number is the power to which e would have to be raised to find that number. Natural logarithms are based on the constant e which is approximately...