IF Function
 

Im having a mind blank!!

I currently have 3 columns populated with customer acknowledgement dates.
the 1st column is the original date and the 2nd & 3rd are any
re-acknowledgement dates.

What I am trying to do is in column 4 put:

Is column 3 is populted put column 3, if not put column 2, if column 2 is
not populated put colum 1.

Tried using IF & AND but can not get it to work.

any ideas?

TheRook

IF Function
 

D1 = =If(C1<"", C1,If(B1<"",B1,A1))

HTH

Charles Chickering

TheRook wrote:
Im having a mind blank!!

I currently have 3 columns populated with customer acknowledgement dates.
the 1st column is the original date and the 2nd & 3rd are any
re-acknowledgement dates.

What I am trying to do is in column 4 put:

Is column 3 is populted put column 3, if not put column 2, if column 2 is
not populated put colum 1.

Tried using IF & AND but can not get it to work.

any ideas?

TheRook

IF Function
 

=IF(C2<"",C2,IF(B2<"",B2,A2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
Im having a mind blank!!

I currently have 3 columns populated with customer acknowledgement dates.
the 1st column is the original date and the 2nd & 3rd are any
re-acknowledgement dates.

What I am trying to do is in column 4 put:

Is column 3 is populted put column 3, if not put column 2, if column 2 is
not populated put colum 1.

Tried using IF & AND but can not get it to work.

any ideas?

TheRook

IF Function
 

If the dates progress, you could also try

=MAX(A2:C2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bob Phillips" wrote in message
...
=IF(C2<"",C2,IF(B2<"",B2,A2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
Im having a mind blank!!

I currently have 3 columns populated with customer acknowledgement
dates.
the 1st column is the original date and the 2nd & 3rd are any
re-acknowledgement dates.

What I am trying to do is in column 4 put:

Is column 3 is populted put column 3, if not put column 2, if column 2
is
not populated put colum 1.

Tried using IF & AND but can not get it to work.

any ideas?

TheRook