If function

[Subhash Sarker]

Dear All,
I am not getting any result using the following even when the conditions are met.

=IF(AND(T9=0,N9=S9<>0,P9=Q9=12,DATE(YEAR(O9),MONTH(9)+(Q9+1),DAY(O9))=E$4),"INTEREST","")

Would be grateful for solution.

Thanks,

[TMS]

Probably something to do with this: "N9=S9<>0" and this: "P9=Q9=12"


Regards, TMS

[dip11]

What TMS is saying, change it to this:
=IF(AND(T9=0,N9=S9,S9<>0,P9=Q9,P9=12,DATE(YEAR(O9),MONTH(9)+(Q9+1),DAY(O9))=E$4),"INTEREST","")

[TMS]

@dip11: you make it too easy