use "if" formula???
 

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

use "if" formula???
 

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

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

use "if" formula???
 

That worked! Thank you so much for your time!!! = )

"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

use "if" formula???
 

If you do have only 4 column ypou can use this but if you will have more, I
think you will need to use Lookup formulas but I need to try more in between,
use this :

=IF(OR(A2=TRUE;B2=TRUE;C2=TRUE;D2=TRUE);"FAIL";"PA SS")

"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

use "if" formula???
 

If you want it to PASS if any one or more is TRUE use the OR operator.

=IF(OR(A2:D2),"PASS","FAIL")


"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