IF, AND/OR, THEN Statement

[JamesVicious]

Ok, so I have been going round and round with this... I have two statements that work perfectly fine by themselves. What I need to figure out, is how to have excel check against both of them, and then return a Statement depending on which one is valid:

=IF(AND(J3=0,D3<TODAY()-45),"YES","NO")

OR

=IF(J3<TODAY()-45,"YES","NO")

Can anyone help me with this??

[teylyn]

maybe like this?

=IF(or(J3<TODAY()-45,AND(J3=0,D3<TODAY()-45)),"YES","NO")