Answer: You can use SEARCH in conjunciton with ISNUMBER to see if the cell contains -500 , then use a second IF statement if it doesn't to ... ... <看更多>

You can't do both things with a validation rule. Validation rules cannot write values to fields. For that, you'd need something like a ... ... <看更多>