More than 7 IF statements

A

Atticus

I am creating a revenue schedule for an item. The total payment is received
over a period of 24 months in 10 installments, each of variable amounts, paid
on variable times, starting from the date of sale (variable again!!!). All
the items are being sold over a 10 years period. I want to be able to
calculate monthly payments (for 10 years or 120 months).

This is how I was doing it for 5 installments:

=IF(Month 1<Sale Date,"", IF(DATEDIF(Sale Date,Month 1,"m")=FI time, FI
amount, IF(DATEDIF(Sale Date,Month 1,"m")= SI time, SI amount,
IF(DATEDIF(Sale Date,Month 1,"m")=TI time, TI amount,IF(DATEDIF(Sale
Date,Month 1,"m")=FoI time, FoI amount, IF(DATEDIF(Sale Date,Month 1,"m")=FiI
time, FiI amount))))))

where,
FI: First Installment
SI: Second Installment
TI: Third Installment
FoI: Fourth Installment
FiI: Fifth Installment

The above formula is used for 120 months i.e. from Month 1 to Month 120.

Now my problem is that I can't use the same formula for 10 installments.
Can somebody help me please?
 
A

Atticus

VBA Noob, I won't be able to drag the master formula to all the 120 cells
(for each month)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top