**Basic mode**for beginners and

**Advanced function**for advanced users.

**Basic mode**

**Advanced function**

**SUM**", select the target columns in the formula pane, and separate the column names with commas. Click

**Confirm**to proceed, and the sum of the columns will be shown.

- •
**SUM(1, 2, 3)**calculates the sum of the three numbers and returns a 6.

- •
**Today() + 1**displays the date after the current date.

- •
**IF(2 > 1, "True", "False")**makes judgement about the condition, and returns either a True or a False.

**Field format**by double-clicking the column header.

- 1.Bitable formulas are much more flexible. It can work on field types other than
**Number**.

**COUNTA**function in Bitable can calculate the number of attachments or multiple choice options you have in a column.

**IF**function. Use checkboxes to indicate attendance, and incorporate them in an IF function to show how many classes are left for each member.

**Basic mode**, subtract the ending time of the task by the starting time, and set the

**Field format**as

**Nearest integer**.

- 2.Bitable syntax supports formula chains, making complex functions easier to compose and more logical to comprehend. You can connect a few formulas into one function without using excessive parentheses.

**Excel**, the function would look like:

**ROUND(SUM(ABS(number column)), 1)**

**Number column.ABS().SUM().ROUND(1)**

- 1.Double-click on a column header to set the
**Field type**of the column as**Formula**, and set the**Field format**as**Nearest integer**.

- 2.Double-click on a cell, and select
**Basic mode**in the bottom-left corner. Subtract the start date from the end date to get the number of days allocatefd for this task.

*Tips**: If the bottom-left corner shows*

*Advanced function**, it means you're already in*

*Basic mode**.*

- 1.Double-click on a column header to set the
**Field type**of the column as**Formula**, and set the**Field format**as**Nearest integer**.

- 2.In
**Data reference**, select the column showing the start dates, enter**+1**, and the expected completion dates will be shown.

- 1.Double-click on a column header to set the
**Field type**of the column as**Formula**, and set the**Field format**as**Nearest integer**.

- 2.Select the column showing the dates the orders were placed and enter
**+14**. The shipping deadline for each order will be automatically calculated.

- 3.To calculate the number of days left, create a column and set the
**Field type**as**Formula**. Using the**ROUND()**function, subtract the current date from the shipping deadline.

- 4.To check whether an order is overdue, use the
**IF**function. If the the number of days remaining is greater than 0, the order is not overdue. Otherwise, the order is overdue.

Formula function | Example and relevant arguments |

TODAY: Returns the current date. | TODAY() |

DATE: Converts year, month, and day values into date format. | DATE(1969, 7, 20) Year, month, day. |

NOW: Returns the current date and time. | NOW() |

DATEDIF: Returns the number of days, months, or years between two dates. | DATEDIF("1969-7-16", "1969-7-24", "Y") Start date must be of one of the following types: Reference to a cell that contains a date, a function that returns date-type data, or a date. End date must be of one of the following types: Reference to a cell that contains a date, a function that returns date-type data, or a date Unit is the abbreviated string of a time unit. Valid values include: "Y", "M", "D", "MD", "YM", and "YD". |

DAYS: Returns the number of days between two dates. | DAYS("1969-7-24", "1969-7-16") End date: the end date of the date range. Start date: the start date of the date range. |

YEAR: Returns the year of a specified date. | YEAR("1969-7-20") Date: The date from which the year value is extracted. |

MONTH: Returns the month of a specified date. | MONTH("1969-7-20") Date: The date from which the month value is extracted. |

DAY: Returns the day of a specified date. | DAY("1969-7-20") Date: The date from which the day value is extracted. |

HOUR: Returns the hour of a specified time. | HOUR("11:40:59") Time: The time from which the hour value is extracted. |

MINUTE: Returns the minute of a specified time. | MINUTE("11:40:59") Time: The time from which the minute value is extracted. |

SECOND: Returns the second of a specified time. | SECOND("11:40:59") Time: The time from which the second value is extracted. |

NETWORKDAYS: Returns the number of working days within a time period. | NETWORKDAYS("1969-7-16", "1969-7-24", LIST("1969-7-22")) Start date: The start date of a period. End date: The end date of a period. Holiday: Two-day weekend applies by default, added by the range or array constant that has been listed in this parameter. |

WEEKDAY: Returns the number of weekdays within a time period. | WEEKDAY("1969-7-20", 1) Date must be of one of the following types: Reference to a cell that contains a date, a function that returns date-type data, or a number. Type represents the first day of the week. If a week starts from Sunday, the value is "1". If a week starts from Monday, the value is "2". |

WEEKNUM: Returns the week number for a given date in that year. | WEEKNUM("1969-7-20", 1) Date must be of one of the following types: Reference to a cell that contains a date, a function that returns date-type data, or a date. Type represents the first day of the week. If a week starts from Sunday, the value is "1". If a week starts from Monday, the value is "2". |

WORKDAY: Returns a total number of working days within a time frame. | WORKDAY(DATE(1969,7,20), 4, LIST("1969-7-17", "1969-7-19")) Start date must be of one of the following types: Reference to a cell that contains a date, a function that returns date-type data, or a date. Days: The number of work days from the start date "forward". If its value is negative, it means the number of work days from the start date "backward". Days counts the number of working days from the start date onwards. A negative value means counting the number of working days from the start date back into the past. Holiday: By default, a weekend has 2 days. |

SUM: Calculates the sum of values of multiple cells. | SUM(2, 101) The arguments can be either numbers of ranges of numbers. |

AVERAGE: Calculates the arithmetic mean of multiple cells. Text value will be ignored. | AVERAGE(2, 100) The arguments can be either numbers of ranges of numbers. |

COUNTA: Calculates the number of existing values in a data range. | COUNTA(attachment column) The arguments define the set of values to count. |

ROUNDDOWN: Rounds down a value to a specified decimal point. | ROUNDDOWN(99.44, 1) Value: The value to be rounded down. Decimal point: the number of decimals to be kept. "1" refers to one decimal place, "2" refers to two decimal points, and "-1" refers to integer. |

ROUND: Rounds the value to a specified decimal point. | ROUND(99.44, 1) Value: The value to be rounded. Decimal point: the number of decimals to be kept. "1" refers to one decimal place, "2" refers to two decimal points, and "-1" refers to integer. |

ROUNDUP: Rounds up the value to a specified decimal point. | ROUNDUP(99.45, 1) Value: the value to be rounded up. Decimal point: the number of decimals to be kept. "1" refers to one decimal place, "2" refers to two decimal points, and "-1" refers to integer. |

MAX: Returns the maximum value in a data set. | MAX(2, 42) The arguments define a range of values from which the maximum value will be determined. |

MIN: Returns the minimum value in a data set. | MIN(2, 5) The arguments define a range of values from which the minimum value will be determined. |

ABS: the absolute value of a value or a list of values. | ABS(-2) The arguments define a range of values of which the absolute values will be determined. |

IF: Runs a logical test for the expression entered. Returns one value for a TRUE results, and another value for a FALSE result. | IF("a" = "b", "Results are equal", "Results are unequal") Logical expression: The expression to be tested which has a binary outcome. TRUE value: Value to be returned if the logical test returns a TRUE result. FALSE value: Value to be returned if the logical test returns a FALSE result. |

AND: Runs logical tests for multiple logical expressions. Returns TRUE value only if all logical expressions are true. | AND(1=1, 1=2) The arguments are logical expressions with binary outcomes. |

OR: Runs logical tests for multiple logical expressions. Returns TRUE value if any of the logical expression are true. | OR(1=2, 1=1) The arguments are logical expressions with binary outcomes. |

NOT: Returns the opposite result of a logical expression. | NOT(TRUE) Logical expression: Any expression that returns either a TRUE or a FALSE result. |

TRUE: The logical value of TRUE result is returned. | TRUE() |

FALSE: The logical value of FALSE result is returned. | FALSE() |

IFERROR: If the first argument is not an error value, returns the first argument. If the first argument is an error value, and the second argument exists, returns the second argument; otherwise, returns a blank value. | IFERROR("No error", "Error") First argument: The value to be returned if it itself isn't an error value. Second argument: The value to be returned if the first argument is an error value. |

ISERROR: Checks whether a value is an error value. | ISERROR(A2) Value: The value to be checked. |

MID: Returns a specified substring within a string. | MID("Bitable", 1, 2) String: The string from which a substring would be extracted. Start point: Specifies the position in the string to start the extraction. The index of the first character in a string is 1. Length of extraction: The number of characters to be extracted. |

LEFT: Returns the substring extracted from the beginning part of a string. | LEFT("Bitable", 2) String: The string from which a substring would be extracted. Length of extraction: The number of characters to be extracted from the left side of the string. |

RIGHT: Returns the substring extracted from the ending part of a string. | RIGHT("Bitable", 2) String: The string from which a substring would be extracted. Length of extraction: The number of characters to be extracted from the right side of the string. |

LEN: Returns the length of a specified string. | LEN("Bitable") String: The string with its length to be determined. |

TRIM: Removes repeated spaces in the beginning and the end of a string. | TRIM(" lorem ipsum") String: The text of which repeated spaces will be removed. |

UPPER: Converts the letters in a specified string to uppercase. | UPPER("lorem ipsum") Text: To be converted to uppercase. |

LOWER: Converts the letters in a specified string to lowercase. | LOWER("LOREM IPSUM") Text: To be converted to lowercase. |

SUBSTITUTE: Replaces existing text with new text. | SUBSTITUTE("abcdefg", "cde", "xyz", 1) Text: Set the range of text from which the string will be looked for. String: The specific string to be searched for. New string: The string used to replace the original string. Number of replacements: Set the number of target strings that get replaced by the new string. By default, all strings found will be replaced. |

REPLACE: Replaces portion of a string by another string. | REPLACE("abcdefg", 1, 6, "xyz") Text: The text from which a portion of the strings will be replaced. Position: The starting position of the replacement. The index of the first character is 1. Length: The number of characters to be replaced. New string: The string used to replace the original string. |

CONCATENATE: Concatenates a string to the end of another string. | CONCATENATE("hello", "Bitable") String 1: Initial string. String 2: The string to be added to the end of the first string. |

LIST: Displays a list which can contain values or nested lists. | LIST(1,2,3) Values: Multiple values or lists. |