Multiple IF functions

Hi,

Just trying to rephrase what i have understood with your question:

you want a installment amount to be mentioned at the respective dates if the date from column T onwards matches with the date first payment however if the date from the column T matches with the the balloon date then the amount in the Balloon column should be populated.

If this is the case then your formula is correct however just make S2 cell as absolute.

Hope i have understood the problem correctly.

Thank you- that worked!

But as you can see from column T row 1, my months increases over time (naturally).
The first payment is 1. mai 2011, and the amount is 288 690. Thereafter 288 690 installments will occur as a result of what is mentioned in cell N2 (for the loan in row 2 the 288690 installment occurs ever month).

How can I make a formula that gives me those values? So that the first payment is in may 2011, and every month thereafter until the balloon is payed nov. 2013?

Try this:

=IF(AND(T$1>=$P2,T$1<$S2),$O2,0)+IF(T$1=$S2,$R2,0)

Thank you! Works like a sharm

Will do, just have a few more questions.

The over mentioned formula will help me on the loans with monthly installments.
But how can I insert a formula that, if the installments are quartaly, insert the installments correct?
Can I use the OFFSET cmd here?

Is there a field that indicates whether a particular loan is quarterly or monthly?

Yes, in the included excel spreadsheet reference column N reprecents +t months until next installment payment.

=if(and(t$1=$p2,t$1<$s2),$o2,0)+if(and(t$1>$p2,t$1<$s2,offset(t2,0,-1*$n2)>0),$o2,0)+if(t$1=$s2,$r2,0)

Thank you! With a few modifications, it works perfectly!