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

Like this;

DATA-A DATA-B RESULT

1/31/2010 1/31/2010 Valid
2/2/2008 2/2/2008 Expired
6/6/2010 6/6/2010 Enrolled
(Blank) (Blank) Not Enrolled
N/A N/A N/A


If the date is in the future in Column (B) the result will be [Valid].
If the date is in the past in Column (B) the result will be [Expired].
If the Cell in the Column (A)in Future the result will be [Enrolled]
If the Cell in the Column (A) is 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.

See: http://www.ozgrid.com/Excel/seven-nested.htm and
http://www.ozgrid.com/Excel/nested-function-limit.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Khalid A. Al-Otaibi" wrote in
message ...
I don't know why can't I make more than one If formula in one Cell.

Like this;

DATA-A DATA-B RESULT

1/31/2010 1/31/2010 Valid
2/2/2008 2/2/2008 Expired
6/6/2010 6/6/2010 Enrolled
(Blank) (Blank) Not Enrolled
N/A N/A N/A


If the date is in the future in Column (B) the result will be [Valid].
If the date is in the past in Column (B) the result will be [Expired].
If the Cell in the Column (A)in Future the result will be [Enrolled]
If the Cell in the Column (A) is 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.

hi
you can if you nest the formulas.....
try this... i think i got it right.....works on your example.....

=IF(A5="","",IF(A5="N/A","N/A",IF(A5=TODAY(),"Enrolled",IF(B5TODAY(),"Valid" ,IF(B5<TODAY(),"Expired")))))

careful....formula wrapped.

regards
FSt1

"Khalid A. Al-Otaibi" wrote:

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

Like this;

DATA-A DATA-B RESULT

1/31/2010 1/31/2010 Valid
2/2/2008 2/2/2008 Expired
6/6/2010 6/6/2010 Enrolled
(Blank) (Blank) Not Enrolled
N/A N/A N/A


If the date is in the future in Column (B) the result will be [Valid].
If the date is in the past in Column (B) the result will be [Expired].
If the Cell in the Column (A)in Future the result will be [Enrolled]
If the Cell in the Column (A) is 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.