Looking to add: If unapprovedcheckbox__c is checked and the date is >= 7/1/25 than multiply by .2
Current formula is:
IF(AND(ISPICKVAL(Who_Files_SL_Tax__c, "ARMR"), YEAR(Effective_Date__c) >= 2023, ARMR_Agrees_to_Reduced_Fee__c = false),
IF(ISPICKVAL(Commission_Type_ARMR__c, "Percent"),
((Premium__c - Return_Premium__c) * Commission_Payable_ARMR__c) + R_D_Brokerage_Analysis_minus_300__c,
IF(ISPICKVAL(Commission_Type_ARMR__c, "Flat Fee"),
Flat_Fee_Commission_Payable_ARMR__c + R_D_Brokerage_Analysis_minus_300__c,
NULL)
),
IF(ISPICKVAL(Commission_Type_ARMR__c, "Percent"),
((Premium__c - Return_Premium__c) * Commission_Payable_ARMR__c) + R_D_Brokerage_Analysis__c,
IF(ISPICKVAL(Commission_Type_ARMR__c, "Flat Fee"),
Flat_Fee_Commission_Payable_ARMR__c + R_D_Brokerage_Analysis__c,
NULL)
)
)
Any thoughts on the best way to go about doing this?