Formula reflecting mutliple results

Giganews Newsgroups
Subject: Formula reflecting mutliple results
Posted by:  Aline Yiu
Date: Tue, 28 Aug 2007

What formula to write on D column:

To show “fail” when there’s an  “a” or “x” on any column of A, B & C.
To show “pass” when only “b”, or “c” or “e” (not a or x) on A, B & C columns.

A    B    C    D
a    a    x    fail
c    b    x    fail
e    c    b    pass
e    e    a    fail
c    b    c    pass
c    b    b    pass

--
Aline Yiu

Replies