I am trying to write a simple validation rule and for some reason i am just not getting it right.
Here is what i want to do
If recordtype = Franchise, then i need to allow only the foll. numbers in Royalty Admin field. 15,18,20,25,30 these are the valid values. If the recordtype is anything other than Franchise then any value is allowed.
Here is what i have got
AND(
$RecordType.Name = "Franchise", OR( NOT(Royalty_Admin__c = 15) ,NOT(Royalty_Admin__c = 18),NOT(Royalty_Admin__c = 20),NOT(Royalty_Admin__c = 25), NOT(Royalty_Admin__c = 30)) )
This validation rule fires even if i give the right values or wrong values.
UPDATE:@sfdcfox i tried your code and it still fires the validation if enter 18 or 19. Here is the screenshot.