IF(ISNUMBER.... problem

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

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

"Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
news:Xns97BCE8371AF07rosco111@69.28.186.121...
>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

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

"Biff" <biffinpitt@comcast.net> wrote in message
news:eXzF0dlcGHA.4700@TK2MSFTNGP02.phx.gbl...
> 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
>
> "Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
> news:Xns97BCE8371AF07rosco111@69.28.186.121...
>>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 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
>
> "Biff" <biffinpitt@comcast.net> wrote in message
> news:eXzF0dlcGHA.4700@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>> "Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
>> news:Xns97BCE8371AF07rosco111@69.28.186.121...
>>>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
>>
>>
>
>
>

works great thanks!

You're welcome. Thanks for the feedback!

Biff

"Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
news:Xns97BDEB24C93DArosco111@69.28.186.121...
> 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
>>
>> "Biff" <biffinpitt@comcast.net> wrote in message
>> news:eXzF0dlcGHA.4700@TK2MSFTNGP02.phx.gbl...
>>> 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
>>>
>>> "Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
>>> news:Xns97BCE8371AF07rosco111@69.28.186.121...
>>>>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
>>>
>>>
>>
>>
>>
>
> works great thanks!