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.