I can't seem to figure this one out. I am trying to make either a
checkmark, someones intials or a check box (reall doesn't matter which
but check mark would be best) appear in a cell when three other cells
in that same form contain data. The cells that need to be searched
woutl only contain dates but the accutall date entered is irrelevant to
the check box so I would assume that it only needs to search for
generic data. The dates are entered as 05/01/06. Using online help I
have been trying and trying with "=IF(ISNUMBER(SEARCH("/",AND
(G5,H5,I5))),"checkmark","x")
With that formula i always get the false indicator of x