I have a field called status. I need to do a compare: if status is 'dead' then formula=false. if status is anything else, formula = true. There is a status value 'dead-spent'. I want the formula to be true when it's dead-spent but the way I have it written, it doesn't read past 'dead'. Does anyone know how i can differentiate the two? Status can have seven different values(active, inactive, etc....)

If both "dead" and "dead-spent" are statuses that should evaluate to True, then you can check for both.

Edited by Keikoku - 14 Jun 2011 at 9:08am