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")