-
Formula fields help please
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
Log In to reply.
Popular Salesforce Blogs
How Our Favorite Sites and Tools Use Machine Learning | Salesforce Guide
As companies collect more and more data about their customers, an increased amount of duplicate information starts appearing in the data as well, causing a…
How to Integrate Data from Third-party Systems with your Salesforce Org?
This article is prepared by our Salesforce Certified Administrator Veronika Klimova. Certainly! Jitterbit, Zapier, and MuleSoft are three popular platforms for data integrations, each with its own strengths and…
How to Whitelist All IPs in Salesforce?
In the Network Access under Security Controls you might have seen this: "The list below contains IP address ranges from sources that your organization trusts.…
Popular Salesforce Videos
Salesforce Admin Certification Questions and Explained Answers with References to Trailblazers
A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…
Learn How To Crack Salesforce Interview In The First Attempt | Salesforce Salaries
This MindMajix video on How To Crack Salesforce Interview In First Attempt video for both freshers and experienced will help you to learn the key…
Salesforce Chatter Training - Staff
In this video, Kylee Durant provides a Salesforce Chatter Training overview, detailing how to enable and configure chatter groups, as well as create customer groups.
Popular Salesforce Infographics
Salesforce and QuickBooks Integration - Transform your Business
Do you know that you can convert 30% of your opportunities into leads when you integrate Salesforce and QuickBooks together? Sounds Interesting right? Our connector eShopSync…
How to Choose the Right Salesforce Partner
Choosing the right partner is a key factor that could make or break your project’s success. Salesforce is a mighty CRM platform, and that’s why…
Best Salesforce1 SMS Mobile App - 360 SMS App
360 SMS App is a One-stop texting solution platform for almost all kinds of industries including Healthcare, Hospitality, Education, etc. It can be your saviour…