+ Start a Discussion
gilbert8109gilbert8109 

Help with Currency Formula

I need a currency formula field that returns a currency value based on selections in 2 other picklist fields.  The formula should work like this:

 

IF value "x" is selected in picklist 1, and value "x" is also selected in picklist 2, THEN, the formula should return the Amount of the opportunity.

 

I think the currency formula would look something like this:

 

---------------------

IF(

AND(
ISPICKVAL(PracticeArea__c, "DI (Defense/Intelligence)"),
ISPICKVAL(Supporting_Practice_1__c, "DI (Defense/Intelligence)")),

Amount)

 

---------------------

 

Obviously something is wrong with the syntax but I can't figure it out.  Any ideas?

SteveMo__cSteveMo__c

You're almost there, you just need to close it out with an Else result (what do you want the formula to do if the condition is NOT true) 

Here are some tip sheets on creating Formlua fields

https://na2.salesforce.com/help/doc/en/salesforce_formulas_cheatsheet.pdf

 

https://na2.salesforce.com/help/doc/en/salesforce_useful_formula_fields.pdf

ngabraningabrani

Try this. If any of the conditions are not true, the formula returns 0

 

IF(AND(
ISPICKVAL(PracticeArea__c, "DI (Defense/Intelligence)"),
ISPICKVAL(Supporting_Practice_1__c, "DI (Defense/Intelligence)")),Amount, 0)