How to Calculate Shipping Cost with VLOOKUP

  If you are in the transport business or import-export business then you know that shipping cost calculations is an important part of the...

How to Calculate Cumulative Principal Payment Using in Excel

In this article, we will learn how to how to calculate cumulative principal payment using Excel CUMPRINC formula. Scenario : When working wi...

Evaluation of bond value in Excel

In this article, we will learn about how to evaluate bond value in Excel.  For Instance, we have given some data to get the bond value at the end ...

Calculate annuity for Interest rate

In this article, we will learn about how to use the RATE function in excel. For instance, when a series of equal cash flows in equal interval of ti...

How to use the PV and FV function in Excel

In this article, we will learn How to use the PV and FV function in Excel. What is present value and future value ? Amount is volatile and c...

How to Calculate Standard Deviation in Excel

What is the Standard deviation? Well, the standard deviation is a calculated number that represents the dispersion of data from the mean of the data....

How To Make Excel Check Register

If you are trying to maintain sum debit and credit records in excel, you would probably want to have an automated balance column that will calculate t...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.