- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
11-07-2012 08:15 PM
I have an If/Then formula that calculates a Referral Fee (represented by the 500 and 250 numbers in the formula below) by confirming a Treatment Start Date field is populated and if the Treatment Fee is greater than 650 or less than 400.
We need to enhance this formula to reference the Lead/Source field as well, which is a pick list of options, two of which are KIND and KIND CO.
If either KIND or KIND CO are selected, this formula below would be true. However, if any of the other 3 options are selected, this formula should put "0" instead of 250 or 500.
Here's the formula I have so far, can you help me?
IF(AND( NOT(ISNULL(Treatment_Start__c)),Treatment_Fee__c > 650),500,
IF(AND( NOT(ISNULL(Treatment_Start__c)),Treatment_Fee__c > 400),250, NULL
Solved! Go to Solution.
11-08-2012 01:21 AM
Try this formula:
IF(ISPICKVAL( LeadSource , 'KIND') || ISPICKVAL( LeadSource , 'KIND CO'),IF(Treatment_Fee__c > 400,500,250) ,0 )
If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.
Madhan Raja M