Thread: IF Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheRook TheRook is offline
external usenet poster
 
Posts: 57
Default 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