32 BUILT-IN FUNCTIONS

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 arguments

Selects one of two values by condition.

IF(Target_Found, 1, 0)

IFERROR

2 arguments

Returns a fallback value if evaluation fails.

IFERROR(Price / Qty, 0)

AND

1–32 arguments

True if every condition holds.

AND(Target_Found, Gold > 100)

OR

1–32 arguments

True if at least one condition holds.

OR(Target_Found, Shop_Found)

NOT

1 arguments

Inverts a boolean value.

NOT(InventoryFull)

DEFINED

1 arguments

Checks whether a variable was produced.

DEFINED("Target_Found")

SUM

1–32 arguments

Adds numbers together.

SUM(10, 20, 30)

AVERAGE

1–32 arguments

Arithmetic mean.

AVERAGE(10, 20)

MIN

1–32 arguments

Smallest value.

MIN(Gold, 1000)

MAX

1–32 arguments

Largest value.

MAX(Gold, 0)

ABS

1 arguments

Absolute value.

ABS(-10)

ROUND

2 arguments

Rounds to 0–10 decimals (away from zero).

ROUND(12.345, 2)

FLOOR

1 arguments

Rounds down to an integer.

FLOOR(12.8)

CEILING

1 arguments

Rounds up to an integer.

CEILING(12.2)

MOD

2 arguments

Remainder after division.

MOD(Counter, 3)

CLAMP

3 arguments

Clamps value within min and max bounds.

CLAMP(Price, 0, 1000)

LEN

1 arguments

Character count of text.

LEN("Shop")

TRIM

1 arguments

Removes leading and trailing whitespace.

TRIM(" Shop ")

LOWER

1 arguments

Converts text to lowercase.

LOWER("SHOP")

UPPER

1 arguments

Converts text to uppercase.

UPPER("shop")

CONTAINS

2 arguments

Case-sensitive substring check.

CONTAINS(Status, "success")

STARTSWITH

2 arguments

Checks whether text starts with a prefix.

STARTSWITH(Status, "OK")

ENDSWITH

2 arguments

Checks whether text ends with a suffix.

ENDSWITH(Status, "OK")

CONCAT

1–32 arguments

Concatenates text values.

CONCAT("Item", " collected")

LEFT

2 arguments

Takes characters from the left.

LEFT("Shop", 3)

RIGHT

2 arguments

Takes characters from the right.

RIGHT("Shop", 3)

REPLACE

3 arguments

Replaces occurrences in text.

REPLACE("1.000", ".", "")

NUMBER

1 arguments

Parses decimal-dot string to number.

NUMBER("100.5")

TEXT

1 arguments

Converts a value to text.

TEXT(100)

ISNUMBER

1 arguments

Is value numeric?

ISNUMBER(Price)

ISTEXT

1 arguments

Is value text?

ISTEXT(Status)

ISBOOL

1 arguments

Is 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.

Valid syntax does not prove that runtime variable types are correct. Run the producing observation and test against actual values.
Next stepBuild a workflow with these modules ↗Resolve a problem ↗