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.
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.