Formula Errors
There are two types of formula errors. One is the error displayed when you set a formula and the other is the error displayed when you enter records.
Errors Displayed When Setting a Formula
The following section describes the errors you might get when you enter and save a formula on the App Settings page.
Error  Cause and Solution 

You have entered a fullwidth symbol "***". Use a halfwidth symbol "***" or check that the entered value is correct.  This error message appears on the formula setting screen when you entered a fullwidth symbol wrongly, instead of a halfwidth symbol. For example, this error is displayed in the following formula because it contains a fullwidth quotation mark (”). Example: IF=(Option=” On the other hand, this error is not displayed in the following cases.

"***" is entered. If the "***" operator is what you want to use, enter "***" instead.  This error message appears when you enter into the formula input field a specific string that is recognized as a mistyped operator. If what the error message says applies to you, replace the mistyped operator with the correct operator indicated by the message. For details on the operators that can be used in kintone, refer to the following page. Description of Operators 
"***" is entered. If the "***" operator is what you want to use, enter "***" instead.  
The field code (***) in the formula does not exist.  This error message appears due to any one of the following:

Specified field (***) is the field type that cannot be used in formulas. The following items cannot be used in formulas: Record number, Label, Rich text, Text area, Attachment, Link, User selection, Department selection, Group selection, Related records, Assignee, Status, and Category.  This error message appears when the formula contains the field code of a field that cannot be referenced in formulas. Check which fields can be referenced in formulas. Reference: Fields That Can/Cannot Be Referenced in Formulas 
Field references cause an endless loop.  This error message appears when you specify a "Calculated" field in a formula set in another "Calculated" field. The error message appears also when "Calculated" field A is set to reference "Calculated" field A which is set to reference "Calculated" field B. 
Function *** requires *** arguments.  This error message appears when the number of arguments specified for the YEN, DATE_FORMAT, NOT, IF, or CONTAINS function is not enough. 
Function *** requires *** or more arguments.  This error message appears when the number of arguments specified for the AND, OR, or SUM function is not enough. 
Function ROUND (or ROUNDUP/ROUNDDOWN) requires 1 or 2 arguments.  This error message appears when the number of arguments specified for the ROUND, ROUNDUP, or ROUNDDOWN function is not enough. 
Function *** does not exist.  This error message appears when you specified a function which cannot be used in kintone. 
Function *** accepts up to *** arguments.  This error message appears when you specified more than acceptable number of arguments in the formula set for a "Calculated" field or "Text" field. 
Invalid formula format. 
This error message appears when the formula cannot be solved. For example:

Relevant function is not used for the value of the array type. As for values of array types and their usage, refer to the help.  This error message appears when the formula references a "Check box" or "Multichoice" field or when a field in a table is referenced from a field outside the table. In both cases, a formula refers to an "array type field". To refer to a "Check box" or "Multichoice" field in a formula, or to refer to a string type field ("Text," "Radio button," "Dropdown," or "Lookup" field whose source is text) in a table outside from the table, use the CONTAINS function. Note that a formula which resides outside of a table cannot refer to a "Check box" or "Multichoice" field in the table. To refer to a numeric type field ("Calculated" field, "Number" field, or "Lookup" field whose source is a number) in a table outside from the table, use the SUM function. For information on how to use SUM and CONTAINS functions, refer to the following pages. CONTAINS Function: Determine If a Field Contains an Exact Match for a Specified Character String Calculating Fields in Tables 
Errors Displayed When Entering Records
This section explains errors that are displayed in the field where a formula is set, when entering records.
Error  Description 

#CONVERT!  The value cannot be converted. This error message appears when the calculation result of a "Calculated" field is a string type value. The result value in the calculated field should be either number, date and time, date, time or hour. Use a "Text" field if the result is a string type value. For details, refer to the following page. When the Calculation Result in the Calculated Field Is a String (Cause and Solution for #CONVERT! error) 
#PRECISION!  The result value exceeds the number of significant digits. For details on how to set the significant digits, refer to the following page. Setting the Significant Digits of Numbers and the Rounding Method 
#VALUE!  This error message appears when the data type of the value to be calculated is invalid or the use of an operator is incorrect. Example 1: Adding a string to a value Example 2: Using the + operator for concatenating strings For example, any number you entered in a dropdown is treated as a string. It cannot be used for calculation as a number. Reference: Data Types of Values Referenced in Formulas 
#ERROR! (Not for DATE_FORMAT function)  The calculation cannot be performed. For example, when dividing a number by zero (0), exponent exceeds 100 or falls below 100, etc. 
#ERROR! (For DATE_FORMAT function)  This error message appears in the following cases:

If a Formula Set for a "Calculated" Field Returns a String Type Value (Cause and Solution for the #CONVERT! error)
If a formula that returns a string type value is set for a "Calculated" field, the error message #CONVERT! appears.
To display the calculation result, use a "Text" field for the formula. Select Calculate automatically for the "Text" field, and then enter the formula.
This time, the calculation result "Clear" is successfully displayed.