MIS Co-ordinator

How to solve below given example problem of calculation in excel using logical function?

Plan Duration Year       Plan amount       1st year     2nd year     3rd year

        1     364

        3     364

2     360

2     246

4     511

if the customer buy one year plan of instalments so its have to pay 100% amount in 1 year.

and if customer buy 2 year plan of istallment so its have to pay 50% amount in 1 year and except 50% amount will pay in 2nd year.

and if customer buy 3 year plan of installments so its have to pay 50% amount in 1st year and except 50% amount have to pay in two slot 25% in 2nd year and 25% in 3rd year.

for 4 year plan duration will same as 3 year plan ” customer buy 4 year plan of installments so its have to pay 50% amount in 1st year and except 50% have to pay in two slot 25% in 2nd year and 25% in 3rd year”.

Please help with solution 

Thanks & Regards

Vishal Ahmad

Mob: 7042838266

By: Vishal

Leave a Reply

Your email address will not be published. Required fields are marked *