View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default IF NOT Statement

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