Skip Navigation LinksHome > Categories > Code from a Category

Zoho CRM Formula Field Using IF Condition Examples



User Name: jamest85
Name: James Tang
Contact Me: www.datawebcoder.com/ContactUs.aspx
Home Page: www.datawebcoder.com
Google Apps for Work Partner, Certified Zoho CRM Consultant. 7 years experience on Zoho consulting, implementation, and programming using C#, VB, Php..., 15 years of total IT experience including prog... [More]
Viewed Times: 4876
Add Date: 11/29/2011
Show couple of examples for the IF Conditions, it is all about brackets

Lets start a simple one So if you have a Formula field called: "TrueOrFalse", it will show: "True"

Second one:
You want to create a formula number field that returns the following output: If field name contains 'Yellow', then return 265 ; Else if field name contains 'Red' return 295; Else if field name contains 'Blue' return 665; Else return 0. Third one:
A Formula field called: "Over $50 Limits" will show: "Yes" if any one of the 5 fields ("Meals Day 1 $", "Meals Day 2 $", "Meals Day 3 $", "Meals Day 4 $", "Meals Day 5 $" ) value greater than 50, will show "No" if non of the 5 fields value greater than 50.

Post a Comment

Name: (Optional)
Email: (Optional, you can get an email if somebody replys your comments)*
Email me if somebody respons my comment below:
Details**:
Enter Text
as Below:
(case insensitive, if hard to read, click the "get a new one" button)
 
    
* Your email address will not be shared with any third parties for any reason.
** Maximum 1000 charactors.