This site is intended for customers outside Japan.
Would you like to visit a site for Japan customers?
Yes
No
All
All
Kintone
Users & System Administration
Free Trial and Purchasing
English
日本語
中文(简体)
中文(繁體)
Español
ไทย
Learn How to Use Kintone
Learn How to Use Kintone
Administration (Users / System)
Trial and Purchase
Start Guide
Common Kintone Operations
Apps
Data Searching
Notification settings
Portal
Spaces
Guest Spaces
People
Messages
Administration
Mobile Access
Usage Guide
Troubleshooting
User Administration
Security
Configuring Accounts
Problems with Logging In
Free Trial
Purchase
Changing Payment Method
Changing the Contract
Termination
Start guide
Common Kintone operations
Apps
What Is an App?
App Settings Screen
App Settings Items
Creating and managing apps
Designing App Forms
App Form Layout
Fields Available in Kintone
Field Settings
Lookup Settings
Listing Related Records
Setting Formulas
Formula Basics and Errors
References and Data Types
Using Functions
IF Function: Change the Value to Display Depending on a Condition
AND, OR, and NOT Functions: Combine Conditions
SUM Function: Calculate the Total of Numeric Values
ROUND, ROUNDUP, and ROUNDDOWN Functions: Round Off, Round Up, and Round Down Numeric Values
Setting the Round Off, Round Down, or Round Up
DATE_FORMAT Function: Specifying the Display Format of Date and Time
Calculation of Date, Time, and Date and Time
CONTAINS Function: Determine If a Field Contains an Exact Match for a Specified Character String
& Operator: Concatenating Strings and Numbers
YEN Function: Display Calculation Results Rounded and in Japanese Yen
Calculating Fields in Tables
Charts/Tables
Setting app actions
History
Process management
Permission Settings
Categorizing records
Operating apps
Audit Logs and the Import/Export of Data
Views
Webhook Settings
Using records
Records comments
Plug-in
JavaScript and CSS Customization
APIs
Integrating External Services with Kintone
Data searching
Notification settings
Portal
Guest spaces
Spaces
People
Messages
Administration
Mobile access
Usage Guide
Troubleshooting
Kintone Help
Apps
Designing App Forms
Setting Formulas
Using Functions
Using Functions
The permanent link has been copied.
Article Number:040847
Articles in this category
IF Function: Change the Value to Display Depending on a Condition
AND, OR, and NOT Functions: Combine Conditions
SUM Function: Calculate the Total of Numeric Values
ROUND, ROUNDUP, and ROUNDDOWN Functions: Round Off, Round Up, and Round Down Numeric Values
Setting the Round Off, Round Down, or Round Up
DATE_FORMAT Function: Specifying the Display Format of Date and Time
Calculation of Date, Time, and Date and Time
CONTAINS Function: Determine If a Field Contains an Exact Match for a Specified Character String
& Operator: Concatenating Strings and Numbers
YEN Function: Display Calculation Results Rounded and in Japanese Yen
Calculating Fields in Tables
In this article
English
Español
ภาษาไทย