Activity Forums Salesforce® Discussions Formula fields help please

  • Formula fields help please

    Posted by Eddie on April 30, 2021 at 11:24 am

    Hello all,
    I am need with help with my formula, I want it to do a calculation based on a criteria using formula fields this how my formula looks:
    IF(
    IF( ISBLANK( npsp__Primary_Contact__c ) , value_if_true, value_if_false),
    IF( Payment_method__c NOT( CONTAINS(paypal, debit card, mastercard, stewardship, work for good ) ) ,
    IF( StageName CONTAINS(post, secured) ,
    IF( Contact__r.Funding__c , yes)
    Amount - ( Amount * 0.8)
    ))))
    Any help on how I can this working please
    If this criteria is met:
    - primary contact is not blank a field
    - payment method (picklist field) is not paypal, debit card, mastercard, stewardship, work for good
    - stage (picklist field) is either posted or secured
    - funding (picklist field) equals yes
    If criteria is met I would want this to be calculated Amount - ( Amount * 0.8)
    Any help would be appreciated.
    Many Thanks

    Eddie replied 2 years, 12 months ago 1 Member · 0 Replies
  • 0 Replies

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Popular Salesforce Infographics