use "if" formula???
On Fri, 02 Jan 2009 18:26:32 GMT, Lars-Åke Aspelin
wrote:
On Fri, 2 Jan 2009 10:17:01 -0800, taurus99
wrote:
How do I get cell E to return PASS OR FAIL, if any the cells A1:AD equal TRUE?
A B C D E
TRUE FALSE TRUE FALSE FAIL
Assuming AD should be read as D1 you may try this in cell E1:
=IF(AND(A1:D1),"PASS","FAIL")
Hope this helps / Lars-Åke
The formula i proposed will return "PASS" if all four cells are TRUE,
otherwise it will return "FAIL".
You can experiment by swaping the "PASS" and "FAIL" and/or replacing
AND with OR in the proposed formula to get the result you are after.
Hope this helps / Lars-Åke
|