Formula library
Combine logic, mathematics and text processing with typed expressions and ready-to-copy examples.
Expression syntax
Write numbers as 10 or 12.5, text in double quotes and booleans as true/false. Variables are unquoted. Operators include + - * / %, comparisons and && || !. Separate function arguments with commas or semicolons; use a decimal point.
Produce values first
Target_Found is only available after the relevant search. Undefined variables raise errors. Numbers and text have different types: NUMBER("100.5") converts, while ISNUMBER checks the actual type.
Bounded evaluation
IF evaluates the selected branch; IFERROR evaluates its fallback when needed. Expressions use allowed built-ins, not arbitrary Python/C# or external I/O. Not every text or numeric editor is a formula field.
32 built-in functions
32 functions
IF
3 argumentsSelects one of two values by condition.
IF(Target_Found, 1, 0)IFERROR
2 argumentsReturns a fallback value if evaluation fails.
IFERROR(Price / Qty, 0)AND
1–32 argumentsTrue if every condition holds.
AND(Target_Found, Gold > 100)OR
1–32 argumentsTrue if at least one condition holds.
OR(Target_Found, Shop_Found)NOT
1 argumentsInverts a boolean value.
NOT(InventoryFull)DEFINED
1 argumentsChecks whether a variable was produced.
DEFINED("Target_Found")SUM
1–32 argumentsAdds numbers together.
SUM(10, 20, 30)AVERAGE
1–32 argumentsArithmetic mean.
AVERAGE(10, 20)MIN
1–32 argumentsSmallest value.
MIN(Gold, 1000)MAX
1–32 argumentsLargest value.
MAX(Gold, 0)ABS
1 argumentsAbsolute value.
ABS(-10)ROUND
2 argumentsRounds to 0–10 decimals (away from zero).
ROUND(12.345, 2)FLOOR
1 argumentsRounds down to an integer.
FLOOR(12.8)CEILING
1 argumentsRounds up to an integer.
CEILING(12.2)MOD
2 argumentsRemainder after division.
MOD(Counter, 3)CLAMP
3 argumentsClamps value within min and max bounds.
CLAMP(Price, 0, 1000)LEN
1 argumentsCharacter count of text.
LEN("Shop")TRIM
1 argumentsRemoves leading and trailing whitespace.
TRIM(" Shop ")LOWER
1 argumentsConverts text to lowercase.
LOWER("SHOP")UPPER
1 argumentsConverts text to uppercase.
UPPER("shop")CONTAINS
2 argumentsCase-sensitive substring check.
CONTAINS(Status, "success")STARTSWITH
2 argumentsChecks whether text starts with a prefix.
STARTSWITH(Status, "OK")ENDSWITH
2 argumentsChecks whether text ends with a suffix.
ENDSWITH(Status, "OK")CONCAT
1–32 argumentsConcatenates text values.
CONCAT("Item", " collected")LEFT
2 argumentsTakes characters from the left.
LEFT("Shop", 3)RIGHT
2 argumentsTakes characters from the right.
RIGHT("Shop", 3)REPLACE
3 argumentsReplaces occurrences in text.
REPLACE("1.000", ".", "")NUMBER
1 argumentsParses decimal-dot string to number.
NUMBER("100.5")TEXT
1 argumentsConverts a value to text.
TEXT(100)ISNUMBER
1 argumentsIs value numeric?
ISNUMBER(Price)ISTEXT
1 argumentsIs value text?
ISTEXT(Status)ISBOOL
1 argumentsIs value boolean?
ISBOOL(Target_Found)A combined example
Initialize Counter = 0 and Delay = 800. Use MIN(Delay + 200, 2000) as a wait duration, Counter < 3 as a loop condition and Counter + 1 to increment the counter.