I need a formula that will compute the total premium paid after a period of time (by months) have elapsed. For example i am paying 1000 a month. After 18 months it will appear as 18000 and after 19 months it will appear 19000 and so on......and how will you express dates on the formula?

There are a number of possibilities, some very simple, but it all depends on how your spreadsheet is set up and used. Please click on the following line and read the instructions on how to post example data in this forum (or use the screen capture feature) and post an example of your set up so that we can offer a solution that will work for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll