Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having trouble with function. | Excel Worksheet Functions | |||
Having trouble with function. | Excel Worksheet Functions | |||
Having trouble with AVG Function | Excel Worksheet Functions | |||
IF function trouble | Excel Worksheet Functions | |||
function trouble | Excel Programming |