if statement with 2 conditions

[smazza]

I need to write a formula that says if the month in cell M5 is >= to the start date in F7, then take the beginning yrs. rent in D7 & multiply it times J7. I have that part of the formula & it's working, but what I need to add is annual 3% increase to the amount in c1, so that every 12 months, the amount of rent increases by 3%.

so far I have...

=IF(M$5>=$F7,($D7*$J7),"") this part works perfectly, I need to add to this formula...

IF(M$5 is 12 months >, then $D7*DJ7*1.03, if it's 24 months> then $D7*$J7*1.0609)

or is there just a way to tell it to increase by 3% every 12 months?

 

[arlene_fool]

you can have multiple arguments in an if formula

if(m$5>=$f7,(if(m$5 is 12 months,$d7*DJ7*1.03,(if(24 months,$D7*$J7*1.0609,$D7*$J7),""),"")

you might want to try posting your sheet so we can see it if that doesnt help