I am working through a formula use case where I am trying to produce a number based on multiple IF statements that add numeric values depending on whether they are True or False. The first three IF statements are all working as expected, but the last two using DSO_eMASS_System__r.System_Type__c don't seem to impact the number. Here is my formula so far:
IF( AND( DSO_eMASS_System__r.Non_Compliant_Controls__c <= 0, DSO_eMASS_System__r.Compliant_Controls__c <= 0 ), +2, IF( AND( DSO_eMASS_System__r.Non_Compliant_Controls__c >= 1, DSO_eMASS_System__r.Non_Compliant_Controls__c <= 25 ), +1, IF( AND( DSO_eMASS_System__r.Non_Compliant_Controls__c >= 26, DSO_eMASS_System__r.Non_Compliant_Controls__c <= 125 ), +2, IF( DSO_eMASS_System__r.Non_Compliant_Controls__c >= 126, +3, IF( ISPICKVAL(DSO_eMASS_System__r.System_Type__c, "IS_Enclave"), +2, IF( ISPICKVAL(DSO_eMASS_System__r.System_Type__c, "Platform_IT_System"), +2, 0 ) ) ) ) ) )
System_Type__cvalues mutually exclusive? If so, then if any of your earlier
IFstatements evaluate to TRUE, then those last two will not ever be touched.