# Using Conditional Formula

The conditional formula set up in Zoho Forms allows you to configure your form to perform certain calculations based on your respondents' answers. These predefined conditions are simple to set up and they will tailor your form to your user's needs. With Conditional Formula you can perform data-driven calculations, and provide customized auto-filled payments, which means the form will provide customers with a unique payment amount with the calculated mathematical output, saving you the burden of calculating for each case.

## Overview

A condition refers to a setup which will include the following 3 things:

1. The field(s) to be checked.
1. The condition to be satisfied (is, is not, is empty, etc).
1. The mathematical calculation to be performed.

This is similar to the If and Else conditions that you use in Excel. When the condition is found to be true, it executes a certain mathematical calculation and when found to be false, it moves on to the next condition.
You can even set  multiple conditions, where the fields can be checked for multiple answers to perform a distinct calculations.
To understand this better, here are a few scenarios:
1. Waive off a 50% discount on the total purchases on more than five shirts.
1. Calculate taxes based on the annual income range.
1. Offer a discount of 20\$ upon the coupon code of DISCOUNT20SPRING.
1. Offer a bulk discount of 100\$ if the total purchase amount is above a threshold value.
Check out how to configure a few of these examples.

## Setup

To set up conditional formula,
2. In the pop-up, click
3. In the Conditional Formula pop-up, set up the necessary logic.
4. Choose All or Any, from the dropdown.
5. To add more conditions, click theicon.
6. Under Perform when none of the conditions is met, set up the formula that will be performed when none of the conditions is found to be true. This is also referred to as a default expression.
7. To delete a condition, click theicon.

You can add more than one condition to perform calculations. This will be useful when you want to check the field for multiple answers and perform distinct mathematical calculations based on it. For example, in a scenario where you are expecting numerous coupon codes to waive off appropriate discounts during your spring sale, you can process the coupon codes in simpler steps. The payment will differ for each customer based on the type of coupon they own.

## Examples

Scenario 1:  Processing the coupon code DISCOUNT20 to waive off 20% on the total price of the purchase.

Scenario 2 Waiving off 100\$ on the total price of the shirts upon the orders of 5 or more.

Scenario 3:  Deciding the tax based on the annual income range of the employee.

## Supported Operators

Text and field comparison
1. IsChecks if the selected field is equal to the set value
2. Is Not: Checks if the selected field is not equal to the set value
3. Is Empty: Checks if the selected field is empty
4. Is Not Empty: Checks if the selected field is not empty
5. Contains: Checks if the selected field contains a value in the condition
6. Not Contains: Checks if the selected field does not contain a value in the condition
7. Contains Any Of: Checks if a field contains any of the selected choices
8. Contains All Of: Checks if a field contains all of the selected choices
9. Contains None Of: Checks if a field contains none of the selected choices
10. Starts With: Checks if the selected field starts with the given value
11. Ends With: Checks if the selected field ends with the given value
Choice and selection
1. Other Choice Is Not Empty: Checks if a value is entered in the Other choice
2. Is Any Of: Checks if any of the choices chosen in the condition match
3. Is None Of: Checks if none of the choices chosen in the condition match
Numeric Comparison
1. Less Than: Checks if a number is less than a given value
2. Greater Than: Checks if a number is greater than a given value
3. Less Than or Equal To: Checks if a number is less than or equal to a given value
4. Greater Than or Equal To: Checks if a number is greater than or equal to a given value
5. Between: Checks if a number/date is between 2 given values
6. Not Between: Checks if a number/date is not between 2 given values
Date and Time Comparison

Day of the week
1. Day Is: Checks if a date falls on the selected day of the week
2. Day Is NotChecks if a date does not fall on the selected day of the week
3. Is Any of Selected Days: Checks if a date falls on any of the selected days of the week
4. Is None of Selected Days: Checks if a date does not fall on any of the selected days of the week
Relative Days
1. Is Previous Day: Checks if a date falls on the previous day
2. Is Current Day: Checks if a date falls on the current day
3. Is Next Day: Checks if a date falls on the next day
4. Is Before [x] Day(s): Checks if a date falls 'x' number of days before the current date
5. Is After [x] Day(s): Checks if a date falls 'x' number of days after the current date
Week
1. Is Previous Week: Checks if a date falls in the previous week
2. Is Current Week: Checks if a date falls in the current week
3. Is Next Week: Checks if a date falls in the coming week
Month
1. Is Previous Month: Checks if a date falls in the last month
2. Is Current Month: Checks if a date falls in the current month
3. Is Next Month: Checks if a date falls in the next month
4. Month Is: Checks if a date falls in selected month of the year
5. Is Any of Selected Months: Checks if date falls in any of the selected months of the year
6. Is None of Selected MonthsChecks if date does not fall in any of the selected months of the year
Year
1. Is Previous Year: Checks if a date falls in the last year
2. Is Current Year: Checks if a date falls in the current year
3. Is Next Year: Checks if a date falls in the coming year
4. Year Is: Checks if a date falls in selected year
Past and Future
1. Is in the Past: Checks if a date falls in the past
2. Is in the Future: Checks if a date falls in future
Time
1. Time Is BeforeChecks if the time falls before the specified time.
2. Time Is AfterChecks if the time occurs after the specified time.
3. Time Is BetweenChecks if the time falls between two specified times.
4. Time Is Not BetweenChecks if the time is outside the specified time range.
5. Time IsChecks if the time matches the specified time.
6. Time Is NotChecks if the time does not match the specified time.
Time on previous day
1. Is Previous Day BeforeChecks if the time on the previous day is earlier than a specified time.
2. Is Previous Day AfterChecks if the time on the previous day is later than a specified time.
3. Is Previous Day BetweenChecks if the time on the previous day is within a specified time range.
4. Is Previous Day Not BetweenChecks if the time on the previous day is not within a specified time range.
5. Is Previous Day AtChecks if the time on the previous day matches a specified time.
6. Is Previous Day Not AtChecks if the time on the previous day does not match a specified time.
Time on current day
1. Is Current Day BeforeChecks if the time on the current day is earlier than a specified time range.
2. Is Current Day AfterChecks if the time on the current day is later than a specified time range.
3. Is Current Day BetweenChecks if the time on the current day is between a specified time range.
4. Is Current Day Not BetweenChecks if the time on the current day is outside a specified time range.
5. Is Current Day AtChecks if the time on the current day matches a specified time.
6. Is Current Day Not AtChecks if the time on the current day does not match a specified time.
Time on next day
1. Is Next Day BeforeChecks if the time on the next day is earlier than a specified time.
2. Is Next Day AfterChecks if the time on the next day is later than a specified time.
3. Is Next Day BetweenChecks if the time on the next day is within a specified time range.
4. Is Next Day Not BetweenChecks if the time on the next day is outside a specified time range.
5. Is Next Day AtChecks if the time on the next day matches a specified time.
6. Is Next Day Not AtChecks if the time on the next day does not match a specified time.
Boolean Comparison
1. True:  Checks if logical TRUE value is returned
2. False: Checks if logical FALSE value is returned
The following table lists the operators that can be used with the corresponding field types to form a rule criteria in the If section:

 Field Types Supported Operators Name Is EmptyIs Not EmptyContainsNot ContainsContains Any OfContains None Of Name - FirstName - Last IsIs Not Is EmptyIs Not EmptyIs Any OfIs None Of  ContainsNot ContainsContains Any OfContains None Of Single LineMulti LinePhone IsIs NotIs EmptyIs Not EmptyContainsNot ContainsStarts WithEnds WithIs Any OfIs None Of NumberDecimalCurrencyRatingFormula IsIs NotIs EmptyIs Not EmptyLess ThanGreater ThanLess Than or Equal ToGreater Than or Equal ToBetweenIs Any OfIs None Of Website IsIs NotIs EmptyIs Not EmptyStarts WithEnds WithIs Any OfIs None Of Address Is EmptyIs Not EmptyContainsNot ContainsContains Any OfContains None Of Address - Street AddressAddress - Address Line 2Address - CityAddress - State/Region/ProvinceAddress - Postal/Zip Code IsIs NotIs EmptyIs Not EmptyContainsNot ContainsIs Any OfIs None OfContains Any OfContains None Of Address - Country IsIs NotIs EmptyIs Not EmptyIs Any OfIs None Of EmailWebsite IsIs NotIs EmptyIs Not EmptyStarts WithEnds With Date IsIs NotIs EmptyIs Not EmptyLess ThanGreater ThanBetweenNot BetweenIs Any OfIs None OfGreater than or Equal toLess than or Equal toDay IsDay Is NotIs Previous DayIs Current DayIs Next DayIs Before [x] Day(s)Is After [x] Day(s)Is Previous WeekIs Current WeekIs Next WeekIs Previous MonthIs Current MonthIs Next MonthIs Previous YearIs Current YearIs Next YearMonth IsYear IsIs in the PastIs in the FutureIs Any of Selected DaysIs None of Selected DaysIs Any of Selected MonthsIs None of Selected Months Date-Time IsIs NotIs EmptyIs Not EmptyLess ThanGreater ThanBetweenNot BetweenIs Any OfIs None OfGreater than or Equal toLess than or Equal toDay IsDay Is NotIs YesterdayIs TodayIs TomorrowIs Before [x] Day(s)Is After [x] Day(s)Is Previous WeekIs Current WeekIs Next WeekIs Previous MonthIs Current MonthIs Next MonthIs Previous YearIs Current YearIs Next YearMonth IsYear IsIs in the PastIs in the FutureIs Any of Selected DaysIs None of Selected DaysIs Any Of Selected MonthsIs None Of Selected MonthsIs Previous Day BeforeIs Previous Day AfterIs Previous Day BetweenIs Previous Day Not BetweenIs Previous Day AtIs Previous Day Not AtIs Current Day BeforeIs Current Day AfterIs Current Day BetweenIs Current Day Not BetweenIs Current Day AtIs Current Day Not AtIs Next Day BeforeIs Next Day AfterIs Next Day BetweenIs Next Day Not BetweenIs Next Day AtIs Next Day Not AtTime Is BeforeTime Is AfterTime Is BetweenTime Is Not BetweenTime IsTime Is Not Time IsIs NotIs EmptyIs Not EmptyLess ThanGreater ThanBetween Decision BoxTerms and Conditions TrueFalse RadioDropdown IsIs NotIs EmptyIs Not EmptyStarts WithEnds WithOther Choice Is Not EmptyIs Any OfIs None Of Multiple ChoiceCheckboxImage Choices ContainsNot ContainsIs EmptyIs Not EmptyContains Any OfContains All OfContains None Of Matrix Choice IsIs NotIs EmptyIs Not Empty Slider IsIs NotLess ThanGreater ThanLess Than or Equal ToGreater Than or Equal ToBetween Signature Is EmptyIs Not Empty

Refer to the FAQs on performing calculations using conditional formula.

### Zoho CRM Training Programs

Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

Redefine the way you work
with Zoho Workplace

### Zoho DataPrep Personalized Demo

If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

Create, share, and deliver

beautiful slides from anywhere.

Zoho Sign now offers specialized one-on-one training for both administrators and developers.

 Quick Links Workflow Automation Data Collection Web Forms Enterprise Begin Data Collection Interactive Forms Workplace Data Collection App Offline Forms Customer Service Accessible Forms Digital Forms Marketing Forms for Small Business HTML Forms Education Forms for Enterprise Contact Forms E-commerce Lead Generation Forms Healthcare Wordpress Forms Customer onboarding No Code Forms Construction Free Forms Travel Prefill Forms Non-Profit Intake Forms Legal Form Designer HR Card Forms Assign Forms Translate Forms Electronic Forms Notification Emails for Forms Holiday Forms Form to PDF HIPAA Forms

Zoho Pagesense Resources

New to Zoho Survey?

Manage your brands on social media

Zoho Desk Resources

• Desk Community Learning Series

• Digest

• Functions

• Meetups

• Kbase

• Resources

• Glossary

• Desk Marketplace

• MVP Corner

• Word of the Day

# Zoho Sheet Resources

New to Zoho Forms?

# Zoho Forms Resources

communication with Zoho Mail

Mail on the move with
Zoho Mail mobile application

Stay on top of your schedule
at all times

Anytime, anywhere

# Zoho Sign Resources

Sign, Paperless!

Sign and send business documents on the go!

Zoho SalesIQ Resources

# Zoho DataPrep Resources

Zoho DataPrep Demo

Get a personalized demo or POC

Design. Discuss. Deliver.

Create visually engaging stories with Zoho Show.

• # Related Articles

• ## Field Rules

Overview Using the Field Rules, you can choose to show or hide certain form fields to your respondents or set certain fields as mandatory to fill in based on their previous responses on the form. This way, you can let your respondents see only the ...
• ## Page Rules

Overview You can use Page Rules to direct form respondents to a specific page in a multi-page form based on their input. Using multi-page forms with Page Rules is a smart way to ensure that your respondents see only the pages relevant to them while ...
• ## Form Rules

With the Form Rules, you can choose to trigger different actions upon form submission if the defined conditions are satisfied. You can automatically trigger emails, assign tasks, decide on the Thank You page to be displayed or redirect the ...
• ## Using Rules to Automatically Assign Tasks

You can configure rules to automatically assign tasks to your users as soon as a form entry comes in. The records will be assigned as tasks if they satisfy the defined conditions. To do so, In your form builder, navigate to Rules tab > Form Rules and ...
• ## Using the Formula Field

Overview Make your form a math wiz by allowing it to perform calculations. You can total up costs, process grade quizzes, apply discounts, and more! Use the Formula field to set up any form calculation. When your respondents fill in the form, ...
Wherever you are is as good as

# Resources

### Videos

Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.

### eBooks

Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.

### Webinars

Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

### CRM Tips

Make the most of Zoho CRM with these useful tips.