Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is that possible; More than one Formula
I don't know whay I can't inculde more than one formula in one cell.
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]. |