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.