I need a formula

[jimar]

I have 3 columns. I need to put a date into either column 1 or column 2.
There will never be a date in both columns on the same row. In column 3 I
would like it to have a forumula that will allow for "letter" to be displayed
if there is a date in Col 1, "Follow up" if there is a date in column 2 and
"No Reply" if there is no date in col 1 or 2. Can anyone help?

Thanks

[[email protected]]

"jimar" wrote:
> There will never be a date in both columns on the same row.
> In column 3 I would like it to have a forumula that will allow
> for "letter" to be displayed if there is a date in Col 1, "Follow
> up" if there is a date in column 2 and "No Reply" if there is
> no date in col 1 or 2. Can anyone help?

=IF(A1<>"", "Letter", IF(B1<>"", "Follow up", "No reply"))

Note that that does not test specifically for a date, but simply
whether or not the cells are empty. Do you truly need to
distinguish between a cell with a date versus a cell with a
different value or text?

[daddylonglegs]

Assuming your columns are A & B then in C2

=IF(ISNUMBER(A2),"Letter",IF(ISNUMBER(B2),"Follow up","No reply"))

[jimar]

Thanks. This works perfectly.

"[email protected]" wrote:

> "jimar" wrote:
> > There will never be a date in both columns on the same row.
> > In column 3 I would like it to have a forumula that will allow
> > for "letter" to be displayed if there is a date in Col 1, "Follow
> > up" if there is a date in column 2 and "No Reply" if there is
> > no date in col 1 or 2. Can anyone help?
>
> =IF(A1<>"", "Letter", IF(B1<>"", "Follow up", "No reply"))
>
> Note that that does not test specifically for a date, but simply
> whether or not the cells are empty. Do you truly need to
> distinguish between a cell with a date versus a cell with a
> different value or text?