I've found multiple threads answering the question about using multiple logical tests with an if function with Excel 2010, and the consensus approach is:
=IF(AND(Test1,Test2),ValueTrue,ValueFalse)
However, when I try to use this in an array formula I end up with a #VALUE! error.
I am trying...