The IF function is a feature that allows users to implement conditional logic to their calculated fields and text fields with automatic calculations. When applied, target fields can be assigned to return specific values depending on if a written conditional statement has been satisfied for not.

What Does the IF Function Look Like? 

At its most basic level, the IF function can be written as a formula like below:


Users can also include several operators--AND, OR, NOT--in their expressions to incorporate additional branching logic, or use nested functions to layer conditional expressions in sequence.

For a general overview on the IF function, please refer to our help center guide here.

For a more detailed look on how to set these functions up, as well as a practice use case to see the feature in action, please check out the video below:

Have further questions? Please email

Kintone Free Trial CTA

Subscribe to Blog

Try Kintone For Free!

Our clients have built and deployed over 340,000 Kintone applications. Join them by signing up for a free trial–no credit card required–or scheduling a customized product demo.

Try Kintone for freeSchedule a Live Demo