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

[Nicole Seibert]

Hello fellow helpers,
I have created the following equation:

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",O10>500,O10<80),"Incorrectly
Categorized",IF(AND(N10="Small",O10>80),"Incorrectly 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.

 

[Bernie Deitrick]

Nicole,

=IF(AND(N10="Large",O10<500),"Incorrectly
Categorized",IF(AND(N10="Medium",OR(O10>500,O10<80)),"Incorrectly
Categorized",IF(AND(N10="Small",O10>80),"Incorrectly Categorized","OK")))

HTH,
Bernie
MS Excel MVP

 

[Muhammed Rafeek M]

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