IF(AND(etc., etc. ... problem
 

Hello fellow helpers,
I have created the following equation:

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly
Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized")))

And it works, however inelegantly, for the first set of conditions. For the
second and third set it just gives a value of false.

I have tried scrunching up the conditions, and only having one "if true"
statement at the end, but this syntax didn't work either.

Please send help soon.

IF(AND(etc., etc. ... problem
 

Nicole,

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",OR(O10500,O10<80 )),"Incorrectly
Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized","OK")))

HTH,
Bernie
MS Excel MVP


"Nicole Seibert" wrote in message
...
Hello fellow helpers,
I have created the following equation:

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly
Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized")))

And it works, however inelegantly, for the first set of conditions. For the
second and third set it just gives a value of false.

I have tried scrunching up the conditions, and only having one "if true"
statement at the end, but this syntax didn't work either.

Please send help soon.

IF(AND(etc., etc. ... problem
 

Hi
Use this way:
=IF(AND(N10="Large",O10500),"Incorrectly
Categorized",IF(AND(N10="Medium",O1080,O10<=500), "Incorrectly
Categorized",IF(AND(N10="Small",O10=80),"Incorrec tly Categorized")))


"Nicole Seibert" wrote:

Hello fellow helpers,
I have created the following equation:

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly
Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized")))

And it works, however inelegantly, for the first set of conditions. For the
second and third set it just gives a value of false.

I have tried scrunching up the conditions, and only having one "if true"
statement at the end, but this syntax didn't work either.

Please send help soon.