software

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 (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
number is entered the message in cell (A1) would be (quot;openquot;).

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,quot;closedquot;,quot;openquot;)

I don't see any problem w/your formula. Are you getting an error or just an
incorrect result? Are you sure G6=C6? Try increasing the number of decimals
in each cell to be sure you don't have any rounding issues. You may have to
incorporate the Round function in your formula if this is the case.
quot;SBSquot; wrote:

gt; Hi,
gt; I have been able to do a formula that provides a random number in a cell
gt; (C6). Upon entering a matching number in another cell (G6), I want to have a
gt; message (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt;
gt; Am new to formulas and have not been able to figure out what to do from the
gt; office help instructions.
gt;
gt; so far I have a non-working formula:
gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;
gt;
gt;

Hi!

One way:

=IF(AND(ISNUMBER(G6),G6=C6),quot;Closedquot;,quot;Openquot;)

gt; so far I have a non-working formula:
gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)

If G6=C6 and your formula does not work it's possible that your numbers are
not numbers but are TEXT.

Biff

quot;SBSquot; gt; wrote in message
...
gt; Hi,
gt; I have been able to do a formula that provides a random number in a cell
gt; (C6). Upon entering a matching number in another cell (G6), I want to have
gt; a
gt; message (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt;
gt; Am new to formulas and have not been able to figure out what to do from
gt; the
gt; office help instructions.
gt;
gt; so far I have a non-working formula:
gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;
gt;
gt;
Thank you JMB and Bif,

Whether I enter a non-equal or an equal number into G6, I only get the
quot;openquot; 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.

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; One way:
gt;
gt; =IF(AND(ISNUMBER(G6),G6=C6),quot;Closedquot;,quot;Openquot;)
gt;
gt; gt; so far I have a non-working formula:
gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;
gt; If G6=C6 and your formula does not work it's possible that your numbers are
gt; not numbers but are TEXT.
gt;
gt; Biff
gt;
gt; quot;SBSquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt; I have been able to do a formula that provides a random number in a cell
gt; gt; (C6). Upon entering a matching number in another cell (G6), I want to have
gt; gt; a
gt; gt; message (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
gt; gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt; gt;
gt; gt; Am new to formulas and have not been able to figure out what to do from
gt; gt; the
gt; gt; office help instructions.
gt; gt;
gt; gt; so far I have a non-working formula:
gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

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

quot;SBSquot; gt; wrote in message
...
gt; Thank you JMB and Bif,
gt;
gt; Whether I enter a non-equal or an equal number into G6, I only get the
gt; quot;openquot; message. If the formula was working, I would expect to see a change
gt; in
gt; the A1 message (either open or closed) depending upon the actual number
gt; entered into G6. I have checked that the cells are formated as number
gt; instead
gt; of text but my results still do not work.
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; One way:
gt;gt;
gt;gt; =IF(AND(ISNUMBER(G6),G6=C6),quot;Closedquot;,quot;Openquot;)
gt;gt;
gt;gt; gt; so far I have a non-working formula:
gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;gt;
gt;gt; If G6=C6 and your formula does not work it's possible that your numbers
gt;gt; are
gt;gt; not numbers but are TEXT.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;SBSquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt; I have been able to do a formula that provides a random number in a
gt;gt; gt; cell
gt;gt; gt; (C6). Upon entering a matching number in another cell (G6), I want to
gt;gt; gt; have
gt;gt; gt; a
gt;gt; gt; message (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
gt;gt; gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt;gt; gt;
gt;gt; gt; Am new to formulas and have not been able to figure out what to do from
gt;gt; gt; the
gt;gt; gt; office help instructions.
gt;gt; gt;
gt;gt; gt; so far I have a non-working formula:
gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
=G6=C6
is not sufficient to test for equality of floating point numbers; you need
=(G6-C6)=0
where the parentheses are critical; otherwise equality may be declared
dispite differences in the lowest order bits. There can be differences that
Excel will not display, given MS's decision not to display more than 15
significant digits.

If the cells are both numeric and nominally equal (but not equal per this
test), the OP should try either rounding both in his formula or testing for a
suitably small difference.

Jerry

quot;Biffquot; wrote:

gt; Ok, start troubleshooting.........
gt;
gt; Try these formulas:
gt;
gt; =G6=C6
gt; =ISNUMBER(G6)
gt; =ISNUMBER(C6)
gt; =LEN(G6)
gt; =LEN(C6)
gt;
gt; If G6=C6 and BOTH are numeric numbers the results of the first 3 formulas
gt; should be TRUE. The results of the last 2 formulas should be identical.
gt;
gt; Biff
gt;
gt; quot;SBSquot; gt; wrote in message
gt; ...
gt; gt; Thank you JMB and Bif,
gt; gt;
gt; gt; Whether I enter a non-equal or an equal number into G6, I only get the
gt; gt; quot;openquot; message. If the formula was working, I would expect to see a change
gt; gt; in
gt; gt; the A1 message (either open or closed) depending upon the actual number
gt; gt; entered into G6. I have checked that the cells are formated as number
gt; gt; instead
gt; gt; of text but my results still do not work.
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; One way:
gt; gt;gt;
gt; gt;gt; =IF(AND(ISNUMBER(G6),G6=C6),quot;Closedquot;,quot;Openquot;)
gt; gt;gt;
gt; gt;gt; gt; so far I have a non-working formula:
gt; gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt; gt;gt;
gt; gt;gt; If G6=C6 and your formula does not work it's possible that your numbers
gt; gt;gt; are
gt; gt;gt; not numbers but are TEXT.
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;SBSquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi,
gt; gt;gt; gt; I have been able to do a formula that provides a random number in a
gt; gt;gt; gt; cell
gt; gt;gt; gt; (C6). Upon entering a matching number in another cell (G6), I want to
gt; gt;gt; gt; have
gt; gt;gt; gt; a
gt; gt;gt; gt; message (quot;closedquot;) appear in yet another cell (A1) or if a non-matching
gt; gt;gt; gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt; gt;gt; gt;
gt; gt;gt; gt; Am new to formulas and have not been able to figure out what to do from
gt; gt;gt; gt; the
gt; gt;gt; gt; office help instructions.
gt; gt;gt; gt;
gt; gt;gt; gt; so far I have a non-working formula:
gt; gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

gt;If the cells are both numeric and nominally equal

Nominally equal ?

I didn't know that equality had a gray area! lt;ggt;

Biff

quot;Jerry W. Lewisquot; gt; wrote in message
...
gt; =G6=C6
gt; is not sufficient to test for equality of floating point numbers; you need
gt; =(G6-C6)=0
gt; where the parentheses are critical; otherwise equality may be declared
gt; dispite differences in the lowest order bits. There can be differences
gt; that
gt; Excel will not display, given MS's decision not to display more than 15
gt; significant digits.
gt;
gt; If the cells are both numeric and nominally equal (but not equal per this
gt; test), the OP should try either rounding both in his formula or testing
gt; for a
gt; suitably small difference.
gt;
gt; Jerry
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Ok, start troubleshooting.........
gt;gt;
gt;gt; Try these formulas:
gt;gt;
gt;gt; =G6=C6
gt;gt; =ISNUMBER(G6)
gt;gt; =ISNUMBER(C6)
gt;gt; =LEN(G6)
gt;gt; =LEN(C6)
gt;gt;
gt;gt; If G6=C6 and BOTH are numeric numbers the results of the first 3 formulas
gt;gt; should be TRUE. The results of the last 2 formulas should be identical.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;SBSquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thank you JMB and Bif,
gt;gt; gt;
gt;gt; gt; Whether I enter a non-equal or an equal number into G6, I only get the
gt;gt; gt; quot;openquot; message. If the formula was working, I would expect to see a
gt;gt; gt; change
gt;gt; gt; in
gt;gt; gt; the A1 message (either open or closed) depending upon the actual number
gt;gt; gt; entered into G6. I have checked that the cells are formated as number
gt;gt; gt; instead
gt;gt; gt; of text but my results still do not work.
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi!
gt;gt; gt;gt;
gt;gt; gt;gt; One way:
gt;gt; gt;gt;
gt;gt; gt;gt; =IF(AND(ISNUMBER(G6),G6=C6),quot;Closedquot;,quot;Openquot;)
gt;gt; gt;gt;
gt;gt; gt;gt; gt; so far I have a non-working formula:
gt;gt; gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;gt; gt;gt;
gt;gt; gt;gt; If G6=C6 and your formula does not work it's possible that your
gt;gt; gt;gt; numbers
gt;gt; gt;gt; are
gt;gt; gt;gt; not numbers but are TEXT.
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;SBSquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi,
gt;gt; gt;gt; gt; I have been able to do a formula that provides a random number in a
gt;gt; gt;gt; gt; cell
gt;gt; gt;gt; gt; (C6). Upon entering a matching number in another cell (G6), I want
gt;gt; gt;gt; gt; to
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; a
gt;gt; gt;gt; gt; message (quot;closedquot;) appear in yet another cell (A1) or if a
gt;gt; gt;gt; gt; non-matching
gt;gt; gt;gt; gt; number is entered the message in cell (A1) would be (quot;openquot;).
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Am new to formulas and have not been able to figure out what to do
gt;gt; gt;gt; gt; from
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; office help instructions.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; so far I have a non-working formula:
gt;gt; gt;gt; gt; =IF(g6=C6,quot;closedquot;,quot;openquot;)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;