function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Karla Pliego 3Karla Pliego 3 

formula if checkbox is true then do this

I'm trying to build a formula that if the Checkbox Formula_C is true then the Price is substrated from seller concessions and if the box is FAlse, then it just puts the price. I'm doing this but get error messages about extra , or parenthesis. Does anyone know how I can fix it? 

IF(  Formula__c  , 'True')  (Price__c -  Seller_Concessions__c )
IF(  Formula__c  , 'False') Price__c, 0
Karla Pliego 3Karla Pliego 3
BTW the Seller concessions field is a text fied. When I add any formulas to it, it sends the error msg that the expected value is a number but we get text. how do I go around this? The field is a text field that gets updated thru process builder with a number based on another field on a different object 
LBKLBK
Hi Karla,

Try this formula. 
IF(Formula__c = TRUE, Price__c - VALUE(Seller_Concessions__c), Price__c)
Let me know how it goes.
Karla Pliego 3Karla Pliego 3
It worked!!! Thanks!! How do I learn how to write these?? 
LBKLBK

Glad it helped. Please mark your question as solved.

And, here are some resources to practice building formulas.

https://developer.salesforce.com/page/An_Introduction_to_Formulas

https://help.salesforce.com/articleView?id=customize_formulas.htm&type=0

And a Trailhead Module. https://trailhead.salesforce.com/modules/point_click_business_logic/units/formula_fields

Hope this helps.
iLoad LoansiLoad Loans

Help!
 

if(Liability_1_Refinance__c =true, text(Liability_1_Balance__c )& " "& text(Liability_1_Repayment__c) )  

I am getting an Error: Incorrect number of parameters for function 'if()'. Expected 3, received 2
Smita HodiggeriSmita Hodiggeri
Thanks this helped me with my requirement @LBK