Excel Function

Excel DVARP Function

This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column in a list or database based on a given criteria. And the DVARP function can… read more »

Excel DVAR Function

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in a list or database based on a given criteria. The DVAR function is a build-in… read more »

Excel DSUM Function

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you can use the DSUM function to add the numbers in a field of records in… read more »

Excel DSTDEVP Function

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or database that match the given criteria. The DSTDEVP function is a build-in function in Microsoft… read more »

Excel DSTDEV Function

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database that match the given criteria. The DSTDEV function is a build-in function in Microsoft Excel… read more »

Excel DMIN Function

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. The DMIN function is a build-in function in Microsoft Excel and it is categorized as a… read more »

Excel DPRODUCT Function

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT function is a build-in function in Microsoft Excel and it is categorized as a Database… read more »

Excel XIRR Function

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. And if you want to get the internal rate of return for a series of… read more »

Excel VDB Function

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. And it will return a numeric value. The VDB function is a build-in function in… read more »

Excel SYD Function

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric value. The SYD function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel SLN Function

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it will return a numeric value. The SLN function is a build-in function in Microsoft Excel… read more »

Excel PV Function

This post will guide you how to use Excel PV function with syntax and examples in Microsoft excel. Description The Excel PV function returns the present value of a loan or investment based on constant payments and a constant interest rate. So you can use the PV function to get the present value based on… read more »

Excel RATE Function

This post will guide you how to use Excel RATE function with syntax and examples in Microsoft excel. Description The Excel RATE function returns the interest rate per payment period of an annuity. The RATE function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The RATE function is… read more »

Excel PPMT Function

This post will guide you how to use Excel PPMT function with syntax and examples in Microsoft excel. Description The Excel PPMT function returns the payment amount on the principal for a given period for a loan or investment based on constant payments and a constant interest rate. So you can use PPMT function to… read more »

Excel PMT Function

This post will guide you how to use Excel PMT function with syntax and examples in Microsoft excel. Description The Excel PMT function returns the payment amount for a loan or investment based on constant payments and a constant interest rate. The PMT function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel NPV Function

This post will guide you how to use Excel NPV function with syntax and examples in Microsoft excel. Description The Excel NPV function returns the net present value of an investment by using a discount rate and a series of future cash flows (future payments and income). The NPV function is a build-in function in… read more »

Excel NPER Function

This post will guide you how to use Excel NPER function with syntax and examples in Microsoft excel. Description The Excel NPER function returns the number of periods for an investment or loan based on periodic payment amount and a constant interest rate. The NPER function is a build-in function in Microsoft Excel and it… read more »

Excel MIRR Function

This post will guide you how to use Excel MIRR function with syntax and examples in Microsoft excel. Description The Excel MIRR function returns the modified internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually). MIRR considers both the cost of… read more »

Excel ISPMT Function

This post will guide you how to use Excel ISPMT function with syntax and examples in Microsoft excel. Description The Excel ISPMT function used to calculate the interest paid during a specific period of an investment. The ISPMT function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The… read more »

Excel IRR Function

This post will guide you how to use Excel IRR function with syntax and examples in Microsoft excel. Description The Excel IRR function returns the internal rate of return for a series of cash flows and the cash flows must be occurred at regular intervals (monthly or annually). The internal rate of return is the… read more »

Sidebar