Formula referenceリファレンス
Everything a Formula_ formula can contain. Only these operators and functions run — a formula can't reach outside the record, so it's safe to accept from an uploaded workbook.
| You can use | How |
|---|---|
| Arithmetic | + - * /, plus // (whole-number divide), % (remainder) and ** (power). Parentheses group: (a + b) * c. |
| Field references | Bare field names (hotel + meals). A line formula can use a header field with a qualifier — rate from HEADER or HEADER.rate (on a name clash the line's own value wins). |
| Aggregation | sum of <column> (or sum(<column>)) totals a line-item column into a header field; add from <SECTION> to pick the section. |
| Comparisons | > >= < <= = != — a lone = means "equals". They return true / false. |
IF(condition, a, b) | The conditional. Returns the 2nd value when the condition is true, else the 3rd. Nest it for more cases: IF(t > 200, "A", IF(t > 100, "B", "C")). Only the chosen branch runs, so IF(qty > 0, total / qty, 0) is safe when qty is 0. |
| Boolean logic | Combine conditions with AND / OR between them (hotel > 100 AND meals > 20) or as functions AND(…), OR(…), NOT(x). |
| Functions | abs, round, min, max, sum, len, int, float, str. |
Worked examples. The formula goes in the Formula column; the Output Field is the read-only field it fills.
| Output field | Formula |
|---|---|
| line_total | quantity * unit_price |
| grand_total | sum of amount |
| mileage | miles_driven * mileage_rate from HEADER |
| band | IF(total > 100, "High", "Low") |
| tier | IF(t > 200, "A", IF(t > 100, "B", "C")) |
| follow_up | IF(total > 100 AND paid = "no", "Yes", "No") |
A formula can return a number (rounded to 2 decimals), text (IF(hotel > 100, "High", "Low")), or true / false — a true/false result on a boolean field shows as Yes / No.
The sheet may be named
Formula_, Formulas_, or Logic_; Formula_ is the standard, more intuitive spelling. If a formula can't be read, the app skips it with a build warning rather than guessing.