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" wrote in message
...
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")