If Function with TODAY.

[blushikari]

Hello I am not very good with IF functions especially if they are nested. Could someone help me with this.



My current formula in cell o9 is =IF(N9<TODAY(),1,) so that o9 returns a value of 1

I have the same in P9 but saying IF(N9>TODAY(),1,)) so that P9 returns a value of 0.

However I want both these formulas to have another rule (I think it would be IF (and( rule. Basically stating that if another cell in this case L9 says Yes in the box then 09 becomes 0 and not 1 , and if it says NO it will have no impact it will continue to say 1.

Then a new formula in Q9 that says if L9 says yes then Q9 will return a value of 1 and if it says No it will return a value of 1.



Can anyone help me with this If function.



Thank you

 

[Fluff]

Hia & welcome to MrExcel
I can't see what your formula is in O9, but using your formula in P9
=IF(AND(N9>TODAY(),L9="NO"),1,)

 

[blushikari]

Thank you very much Fluff for your help.

 

[Fluff]

Glad to help