basic if statement

[pickwa]

Hi guys im struggling with the basics again

=IF(B2<(TODAY()-40),"yes","no")

this formula works well but is there a way of making it say

=IF(b2<(today()-40 or 0),"yes","no"

so if the value in b2 is 0 or blank it will display also display "NO" as it currently says "yes"

i mite be going about this in the wrong way?

Can anyone advise me?

 

[Jonmo1]

Try

=IF(AND(B2>0, B2<TODAY()-40),"yes","no")


Hope that helps.

 

[pickwa]

Hi thanks for your respones, would i need to encorperate that into my current formula somehow. Appologies i am a complete novice and slightly out of my depth!

Thanks

Nick

 

[pickwa]

=IF(and(B2>0,b2<(TODAY()-40),"yes","no"))

this is what i came up with from the last response.......obviously not quite rite. Feel like such an idiot but i just dont have a clue what im doing when it comes to large statements.

 

[Jonmo1]

Sorry, my formula got cut off due to < > symbols...

should be

=IF(AND(B2 > 0, B2 < TODAY()-40),"yes","no")

 

[pickwa]

Absolute legend mate! really appreciate the help! im slowly getting my head round this program but its going to take a while!

its good of you to help me out!

 

[Jonmo1]

Glad to help, thanks for the feedback.