if, or, true, false?
Do you mean
=IF(COUNTA(Sheet2!A:A)=0,"delinquent","no")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"bdq17" wrote in message
...
I want to create a delinquency report using info from multiple worksheets.
I
have an account column and next to that I want to create a deliquent
column.
In the individual worksheets there is a date column. I want excel to look
at
the cells in that column and return a deliquent message if no date is
present.
|