I thought I had this right....this is a simple ranking system based on $$ amounts:

KEY Revenue
> 200,000 A
100,000 - 199,000 B
< 100,000 C

here is my formula:

Capture.JPG

A and B are coming up just fine...but for revenue that is less than 100,000 it is still coming up B instead of C

any ideas? I am sure it is something simple.