If Formula to Identify Cell

[Khalid A. Al-Otaibi]

0 Valid
0 Expired
Enrolled Valid
0 Expired
Enrolled Expired

If the Cell in Column (1) is the Word (Enrolled), the Result will be
enrolled. If not the Word (Enrolled) the result will be the Column (2).

(Blank) (Blank)
N/A N/A


If the Cell in Column (1) is Blank, the Result will be (Not Enrolled). If
the Cell in Column (2) is (N/A) the resultl will be N/A.

 

[Khalid A. Al-Otaibi]

I don't know why can't I make more than one If formula in one Cell.

Like this;

DATA RESULT

01/31/10 Valid
02/02/08 Expired
06/06/10 Enrolled
(Blank) Not Enrolled
N/A N/A

If the date is in the future in Column (A) the result will be [Valid].
If the date is in the past in Column (A) the result will be [Expired].
If the Cell in the Column (A) is the word (Enrolled) the result will be
[Enrolled].
If the Cell in the Column (A) is the Blank (""), the result will be Blank
("").
If the Cell in the Column (A) is the word (N/A), the result will be [N/A].

I understand if that is hard for me, but it's hard to believe that you don't
know the answer.