Can anyone help me figure out how to add a range from "990 - 994" without having to type each line out (ex 991, 992, 993, 994)? THANKS!
OR(
BEGINS(Ship_To_Zip__c, '835'),
BEGINS(Ship_To_Zip__c, '838'),
BEGINS(Ship_To_Zip__c, '975'),
BEGINS(Ship_To_Zip__c, '976'),
BEGINS(Ship_To_Zip__c, '978'),
BEGINS(Ship_To_Zip__c, '990'),
BEGINS(Ship_To_Zip__c, '991'),
BEGINS(Ship_To_Zip__c, '992'),
BEGINS(Ship_To_Zip__c, '993'),
BEGINS(Ship_To_Zip__c, '994'))
답변 3개
You could do something like this =
OR(
BEGINS(Ship_To_Zip__c, '835'),
BEGINS(Ship_To_Zip__c, '838'),
BEGINS(Ship_To_Zip__c, '975'),
BEGINS(Ship_To_Zip__c, '976'),
BEGINS(Ship_To_Zip__c, '978'),
AND(
NOT(ISBLANK(Ship_To_Zip__c)),
VALUE(LEFT(Ship_To_Zip__c, 3)) >= 990,
VALUE(LEFT(Ship_To_Zip__c, 3)) <= 994
)
)
