Data displayed that is not equal to FALSE in a row
In row 1 cells A1-D1 contain formulas (IF/AND statements). In cell E1 I want
whatever word that is not equal to €śFALSE€ť to be displayed.
A B C D E
1 FALSE FALSE Under FALSE Under
The words can appear in any of cells A-D in each row as below.
A B C D E
1 FALSE FALSE Under FALSE Under
2 FALSE On FALSE FALSE On
3 Over FALSE FALSE FALSE Over
4 FALSE FALSE FALSE On On
Thank you in advance for your help.
|