IF FUNCTION Trouble
 

how do i turn the following into one formula?:
IF(MCS_Seals=FALSE),"SkipItem"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=TRUE),"GetQTY"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=FALSE),"GetItem"
after two days of IF, and IF(AND, and IF(OR, and IF(AND(OR, and etc.
if i press enter one more time and get one more error message
you can visit me at yahoo.looneybin
<i'm not grinning

IF FUNCTION Trouble
 

You can use nested function up to a total maximum of 7 nested levels.
Parts of an IF Function is
(<Criteria,[<WhatToDoIfTrue][,<WhatToDoIfFalse])
Note: One of the last 2 parts at the minimal needs to be provided in
addition to the Criteria

Example as you have shown below:

=IF(MCS_Seals=TRUE,IF(COUNTIF(Code,A25)=TRUE,"GetQ ty","GetItem"),"SkipItem")

By default, the "=TRUE" could be eliminated as if the expression does return
a "TRUE" boolean value (it can be any number other than 0, as the value of 0
equates to the "False" value. However, when a True value is tested for it's
value, it's a -1, but for function purposes of the criteria, any numeric
value other than 0 will cause it to return a True value, when the expression
doesn't have a comparison operator involved.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

"J. Cornor" wrote in message
...
how do i turn the following into one formula?:
IF(MCS_Seals=FALSE),"SkipItem"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=TRUE),"GetQTY"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=FALSE),"GetItem"
after two days of IF, and IF(AND, and IF(OR, and IF(AND(OR, and etc.
if i press enter one more time and get one more error message
you can visit me at yahoo.looneybin
<i'm not grinning

IF FUNCTION Trouble
 

thank you so very much ronald.
first smile i cracked all day.
and thank you for the extra explanation,
i'm going to burn that in the brain.

"J. Cornor" wrote:

how do i turn the following into one formula?:
IF(MCS_Seals=FALSE),"SkipItem"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=TRUE),"GetQTY"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=FALSE),"GetItem"
after two days of IF, and IF(AND, and IF(OR, and IF(AND(OR, and etc.
if i press enter one more time and get one more error message
you can visit me at yahoo.looneybin
<i'm not grinning

IF FUNCTION Trouble
 

thank you so very much ronald
it worked and now i'm grinning
also thank you for the extra explanation
i appreciate it

"Ronald Dodge" wrote:

You can use nested function up to a total maximum of 7 nested levels.
Parts of an IF Function is
(<Criteria,[<WhatToDoIfTrue][,<WhatToDoIfFalse])
Note: One of the last 2 parts at the minimal needs to be provided in
addition to the Criteria

Example as you have shown below:

=IF(MCS_Seals=TRUE,IF(COUNTIF(Code,A25)=TRUE,"GetQ ty","GetItem"),"SkipItem")

By default, the "=TRUE" could be eliminated as if the expression does return
a "TRUE" boolean value (it can be any number other than 0, as the value of 0
equates to the "False" value. However, when a True value is tested for it's
value, it's a -1, but for function purposes of the criteria, any numeric
value other than 0 will cause it to return a True value, when the expression
doesn't have a comparison operator involved.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

"J. Cornor" wrote in message
...
how do i turn the following into one formula?:
IF(MCS_Seals=FALSE),"SkipItem"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=TRUE),"GetQTY"
IF(MCS_Seals=TRUE and COUNTIF(Code,A25)=FALSE),"GetItem"
after two days of IF, and IF(AND, and IF(OR, and IF(AND(OR, and etc.
if i press enter one more time and get one more error message
you can visit me at yahoo.looneybin
<i'm not grinning