-
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
![Apex Batch](https://images.forcetalks.com/wp-content/uploads/2018/09/14135620/FT-Banners-5-33-min-1.jpg)
Apex Batch - Use of Interface Database.Stateful in Batch Class
Hello guys, Today, we will talk about interface named as Database.Stateful, it is used when we want to maintain the state across the batch call…
![What to Expect from Marc Benioff’s Keynote at Dreamforce 2018](https://images.forcetalks.com/wp-content/uploads/2018/09/04140423/FT-Banners-5-10.jpg)
What to Expect from Marc Benioff’s Keynote at Dreamforce 2018
Dreamforce has grown tremendously since its inception. It started in 2003 with around 1,000 attendees. At its 16th edition in 2018, more than 180,000 trailblazers…
![digital transformation](https://images.forcetalks.com/wp-content/uploads/2020/12/18155422/digital-transformation.jpeg)
Why Digital Transformation is Essential for Business Growth? | Salesforce Guide
With reports suggesting that worldwide spending on the technologies enabling digital transformation is forecast to reach $2.3 trillion (£1.8 trillion) in 2023, more and more…
Popular Salesforce Videos
Dreamforce To You 2020 - All Set To Happen
The world has changed, and so has Dreamforce. Instead of everyone coming to Dreamforce, Dreamforce is coming to you — to your kitchen, to your…
Build Your First Custom App On Salesforce
Lightning App Builder makes it super simple to quickly assemble apps using just declarative drag and drop features. This video covers how to upgrade a…
A Must-Have for Admins: Salesforce Profiles, Permission Sets, and Roles Explained
Keeping your data safe and organized is a must-have. Luckily, Salesforce provides all the tools to help administrators control who can see and do what.…
Popular Salesforce Infographics
![](https://images.forcetalks.com/wp-content/uploads/2018/01/25083251/sa_1516178742FT%20Banners%20%202%205.png)
Top 5 ETL Tools for Salesforce Data Migration
There are plenty of ETL tools for Salesforce in the market, with varying degrees of functionality and popularity. All tools are more or less the…
![](https://images.forcetalks.com/wp-content/uploads/2023/02/23130326/sa_1677157385nonprofit%20trends%20for%202023.png)
Leverage Nonprofit trends with Salesforce Nonprofit Cloud
Salesforce Nonprofit Cloud is a suite of tools designed to help nonprofits take advantage of the latest trends and technologies. With the Nonprofit Cloud, your…
![](https://images.forcetalks.com/wp-content/uploads/2018/01/25083302/sa_1516171679FT%20Banners%20%202%204.png)
7 Must Know Features on the New Salesforce AppExchange
Personalized recommendations, intelligent search, and new solutions are just a few of the exciting new features on the brand new AppExchange. Check it out at…