I need 2 function arguments to work together

[kfaucher]

I am going to start with saying that I really have minimal experience with Excel.

What I am trying to blindly accomplish at this time is for the "IF's" in 2 cells to have one answer.

Basically, if Cell L5 is > 365 AND cell N5 is < 1, then the answer is true, if both are not true, then I need it to be false, even if one is true and one is false, I need it to be false.

So I need a formula that will only give me a true if there are 2 trues and a false for any other combination.

Forgive my ignorance and thank you in advance.

 

[Weazel]

maybe something like...

=AND(L5>365,N5<1)

 

[kfaucher]

I need the answer to be a number one for true and 0 for false

You may be on to something here though

 

[Weazel]

maybe

=--AND(L5>365,N5<1)

 

[kfaucher]

It worked! Thank you very much