Try this...
=IF(AND(NOT(ISNUMBER(J12)),NOT(ISNUMBER(K12))),"bo y","girl")
--
Rick (MVP - Excel)
"rtwiss via OfficeKB.com" <u46610@uwe wrote in message
news:8bc49732f7c51@uwe...
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)
--
Message posted via http://www.officekb.com