Ok, start troubleshooting.........

Try these formulas:

=G6=C6
=ISNUMBER(G6)
=ISNUMBER(C6)
=LEN(G6)
=LEN(C6)

If G6=C6 and BOTH are numeric numbers the results of the first 3 formulas
should be TRUE. The results of the last 2 formulas should be identical.

Biff

"SBS" <SBS@discussions.microsoft.com> wrote in message
news:653E5E28-5D7F-4651-B9F1-4B66E21B3CAF@microsoft.com...
> Thank you JMB and Bif,
>
> Whether I enter a non-equal or an equal number into G6, I only get the
> "open" message. If the formula was working, I would expect to see a change
> in
> the A1 message (either open or closed) depending upon the actual number
> entered into G6. I have checked that the cells are formated as number
> instead
> of text but my results still do not work.
>
> "Biff" wrote:
>
>> Hi!
>>
>> One way:
>>
>> =IF(AND(ISNUMBER(G6),G6=C6),"Closed","Open")
>>
>> > so far I have a non-working formula:
>> > =IF(g6=C6,"closed","open")
>>
>> If G6=C6 and your formula does not work it's possible that your numbers
>> are
>> not numbers but are TEXT.
>>
>> Biff
>>
>> "SBS" <SBS@discussions.microsoft.com> wrote in message
>> news:667C39E5-E85A-458A-B2B1-AD24773FD141@microsoft.com...
>> > Hi,
>> > I have been able to do a formula that provides a random number in a
>> > cell
>> > (C6). Upon entering a matching number in another cell (G6), I want to
>> > have
>> > a
>> > message ("closed") appear in yet another cell (A1) or if a non-matching
>> > number is entered the message in cell (A1) would be ("open").
>> >
>> > Am new to formulas and have not been able to figure out what to do from
>> > the
>> > office help instructions.
>> >
>> > so far I have a non-working formula:
>> > =IF(g6=C6,"closed","open")
>> >
>> >
>> >
>>
>>
>>