| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF NOT Statement
What am I do wrong here?
=IF(NOT(ISNUMBER(J12),ISNUMBER(K12)),"boy","girl") -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200810/1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
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? -- Rick (MVP - Excel) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
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") |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
Actually, for what you have described, I think this will do what you want
also... =IF(COUNT(J12:K12)=0,"boy","girl") -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
=IF((AND(NOT(ISNUMBER(J12)),NOT(ISNUMBER(K12))))," Boy","Girl")
Logic Results J12 K12 Results 1 2 Girl 1 A Girl A 1 Girl A A Boy if J12 and K12 are not numbers then boy (True statement), girl (False statement) |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
Excel tells you that there are too many arguments for the function. NOT
takes one argument, not two. What you are trying to achieve is a different question. -- David Biddulph "rtwiss via OfficeKB.com" <u46610@uwe wrote in message news:8bc46c676a3e6@uwe... What am I do wrong here? =IF(NOT(ISNUMBER(J12),ISNUMBER(K12)),"boy","girl") -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200810/1 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
Rick Rothstein wrote:
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. You are probably right... "if J12 and K12 are not numbers then boy (True statement), girl (False statement)" What if J12 is a number and K12 is not? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF NOT Statement
then false
Glenn wrote: 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. You are probably right... "if J12 and K12 are not numbers then boy (True statement), girl (False statement)" What if J12 is a number and K12 is not? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200810/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Linear Mode
