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