View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Khalid A. Al-Otaibi[_2_] Khalid A. Al-Otaibi[_2_] is offline
external usenet poster
 
Posts: 1
Default If Formula to Identify Cell

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.