IF(ISNUMBER.... problem

R

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
 
B

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
 
B

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
 
R

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
Click to expand...

works great thanks!
 
Top