IF(ISNUMBER.... problem

[Rosco]

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

 

[Biff]

Hi!

Here's the formula: (assuming that the dates are true Excel dates and not
just TEXT strings)

=IF(COUNT(G5:I5)=3,"checkmark","x")

Why not use the "x" as the checkmark and maybe a dash (-) to indicate the
condition has not been met:

=IF(COUNT(G5:I5)=3,"X","-")

Biff

 

[Biff]

If you have the Marlett font available......

Use this formula to get a real checkmark if the cells contain dates and a
bold dash (-) if the condition is not met:

=IF(COUNT(G5:I5)=3,CHAR(97),CHAR(48))

Format the cell as font Marlett.

Biff

 

[Rosco]

Biff cried out

If you have the Marlett font available......

Use this formula to get a real checkmark if the cells contain
dates and a bold dash (-) if the condition is not met:

=IF(COUNT(G5:I5)=3,CHAR(97),CHAR(48))

Format the cell as font Marlett.

Biff

works great thanks!

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Biff cried out


works great thanks!