IF NOT Statement
I don't think that does what the OP asked for. Both cells must contain
non-numbers for it to be "boy"... your formula returns "boy" if one is a
number and one is not a number... I'm pretty sure the OP want "girl"
returned for that condition.
--
Rick (MVP - Excel)
"Glenn" wrote in message
...
rtwiss via OfficeKB.com wrote:
Rick Rothstein wrote:
What am I do wrong here?
=IF(NOT(ISNUMBER(J12),ISNUMBER(K12)),"boy","girl")
Depends on what the formula is supposed to be doing. Can you tell us in
words what you expected the formula to do?
if J12 and K12 are not numbers then boy (True statement), girl (False
statement)
=IF(NOT(AND(ISNUMBER(J12),ISNUMBER(K12))),"boy","g irl")
|