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
|