-
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 to Use Amazon Lex in Salesforce?
Amazon spread around “Amazon Lex” in December 2016. It operative the technology used by Alexa, Amazon’s voice-activated virtual assistant which lets user control things with…
How to Use the Salesforce Marketing Cloud for Business Growth in 2024?
Salesforce Marketing Cloud is a leading email marketing software for creating and managing successful marketing campaigns and nurturing customer relationships. This SaaS platform allows marketers to use email personalization to…
Popular Salesforce Videos
Winter 21 - Restrict Access to @AuraEnabled Apex Methods for Authenticated Users
Winter 21 - Restrict Access to @AuraEnabled Apex Methods for Authenticated Users The video explained the following Items: Action items to enable or disable the…
How to Find More Prospects, Win More Deals, and Keep Customer Happy with Salesforce Essentials
Watch this video to learn how to minimize busy work and empower your sales and support teams to spend more time closing deals and engaging…
The Rising Demand for Salesforce Experts | Salesforce Careers
With more than 500,000 organizations using Salesforce to drive key business results, the market is brimming with opportunities for Salesforce certified professionals. A quick job…
Popular Salesforce Infographics
Salesforce Buy Vs Salesforce Build - An Infographic
Uncover the Process that every business should understand at the time of Salesforce implementation and integration. Salesforce Solution Buying Process Search for Required Solution on…
DataArchiva - A Native Data Archiving App for Salesforce using Big Objects
A Native Data Archiving app for Salesforce using Big Objects. With Auto-scheduler, Custom Archiving, Encryption, Integrity and Restore features, DataArchiva saves 85%+ storage costs, improves…
9 Ways Salesforce Brings Companies and Customers Together
As the world’s #1 CRM, Salesforce brings companies and customers together. This is possible through Salesforce Customer 360. It’s an integrated, AI-powered customer relationship management…