My Quick Action button was working fine and then it stopped. It still works in Classic but not in Lightning. I get the error
"You can't perform this action on this page."

I keep receiving a "Missing ) Error"

IF(Acq_Comm_Calc__c CONTAINS $500),Estimated_Net_Profit_Retail_Renovation__c+500,
IF(AND Acq_Comm_Calc__c CONTAINS 8%),Estimated_Net_Profit_Retail_Renovation__c*0.08,
IF(AND Acq_Comm_Calc__c CONTAINS 10%),Estimated_Net_Profit_Retail_Renovation__c*0.1,
IF(AND Acq_Comm_Calc__c CONTAINS 12%),Estimated_Net_Profit_Retail_Renovation__c*0.12,
IF(AND Acq_Comm_Calc__c CONTAINS 15%),Estimated_Net_Profit_Retail_Renovation__c*0.15,
IF(Acq_Comm_Calc__c CONTAINS $7000),Estimated_Net_Profit_Retail_Renovation__c+7000,)
)
)
)
)

)

I am needing help writing out a formula field. If the net income is in a certain range I need the field to display the Net by the % it corresponds with.
=Net Income MLS Wholesale X the percentage level belows


≤ $6000                     $500(flat fee)
> $6,001 ≤ $24,000     8%
> $24,001 ≤ $32,000   10%
> $32,001 ≤ $40,000   12%
> $40,001 ≤ $46,667   15%
> $46,668                 $7,000(flat fee)

 

My Quick Action button was working fine and then it stopped. It still works in Classic but not in Lightning. I get the error
"You can't perform this action on this page."

I keep receiving a "Missing ) Error"

IF(Acq_Comm_Calc__c CONTAINS $500),Estimated_Net_Profit_Retail_Renovation__c+500,
IF(AND Acq_Comm_Calc__c CONTAINS 8%),Estimated_Net_Profit_Retail_Renovation__c*0.08,
IF(AND Acq_Comm_Calc__c CONTAINS 10%),Estimated_Net_Profit_Retail_Renovation__c*0.1,
IF(AND Acq_Comm_Calc__c CONTAINS 12%),Estimated_Net_Profit_Retail_Renovation__c*0.12,
IF(AND Acq_Comm_Calc__c CONTAINS 15%),Estimated_Net_Profit_Retail_Renovation__c*0.15,
IF(Acq_Comm_Calc__c CONTAINS $7000),Estimated_Net_Profit_Retail_Renovation__c+7000,)
)
)
)
)

)

I am needing help writing out a formula field. If the net income is in a certain range I need the field to display the Net by the % it corresponds with.
=Net Income MLS Wholesale X the percentage level belows


≤ $6000                     $500(flat fee)
> $6,001 ≤ $24,000     8%
> $24,001 ≤ $32,000   10%
> $32,001 ≤ $40,000   12%
> $40,001 ≤ $46,667   15%
> $46,668                 $7,000(flat fee)