Excel formulas

Databar supports Excel-style formulas natively, so you never need to export your data to a spreadsheet just to run simple calculations or logic. Add a formula column to any table and get instant, row-level results.

Formulas are a transformation. They are computed locally and do not consume any credits.

How it works

Databar formulas use column references instead of traditional cell references. Instead of writing A2 or B2, you reference columns by name using curly braces: {column_name}. Each formula runs once per row, with the column references swapped for that row’s values. This means every formula is effectively a single-row operation. For example, if you have columns named employee_count and first_name, you would write:

=IF({employee_count}>100, "High", "Low")

How to use

Open your table

Navigate to the table where you want to add formula logic.

Add a formula column

Click Enrich, then select Formulas & Tools. Choose Excel Formula from the list.

Write your formula

Enter any supported Excel formula, referencing columns by name using {column_name} syntax.

View results

Results are computed instantly for every row in your table.

Formula examples

Conditional logic
Text manipulation
Flexible filters
Calculations

Flag companies above a certain employee count:

=IF({employee_count}>100, "High", "Low")

Merge first name and last name into a full name:

=CONCATENATE({first_name}, " ", {last_name})

Combine multiple conditions for complex filtering:

=OR({country}="USA", {headcount}>500)

Round a value or find the max/min:

=ROUND({revenue}, 2)
=MAX({score_a}, {score_b})

Available formulas

Formula	Description	Example
`IF`	Returns one value if a condition is true, another if false	`=IF({score}>80, "Pass", "Fail")`
`OR`	Returns `TRUE` if any argument is true	`=OR({country}="USA", {country}="UK")`
`AND`	Returns `TRUE` if all arguments are true	`=AND({age}>18, {status}="active")`
`SUM`	Adds values together	`=SUM({q1_revenue}, {q2_revenue})`
`CONCATENATE`	Joins text strings into one	`=CONCATENATE({first_name}, " ", {last_name})`
`RANDBETWEEN`	Returns a random integer between two values	`=RANDBETWEEN(1, 100)`
`STDEV`	Calculates the standard deviation of values	`=STDEV({score_a}, {score_b}, {score_c})`
`EOMONTH`	Returns the last day of the month N months from a date	`=EOMONTH({start_date}, 3)`
`ROUND`	Rounds a number to a specified number of digits	`=ROUND({revenue}, 2)`
`MAX`	Returns the largest value from a set of arguments	`=MAX({bid_a}, {bid_b})`
`MIN`	Returns the smallest value from a set of arguments	`=MIN({price_1}, {price_2})`
`TODAY`	Returns today’s date	`=TODAY()`
`LEN`	Returns the number of characters in a text string	`=LEN({description})`
`TRIM`	Removes leading and trailing spaces from text	`=TRIM({raw_name})`
`LOWER`	Converts text to lowercase	`=LOWER({email})`
`UPPER`	Converts text to uppercase	`=UPPER({ticker})`
`MID`	Extracts a substring from the middle of a text string	`=MID({phone}, 2, 3)`

Looking for a different transformation? Use JQ formulas to transform JSON data, Table Lookup for VLOOKUP-style enrichments across tables, Split Text to break a column into multiple columns, or Merge Columns to combine values from several columns into one.

When to use formulas

Quick math on numeric columns (revenue, headcount, scores)
Concatenating text fields without a separate tool
Building conditional flags or labels for filtering and segmentation
Rounding, formatting, or normalizing values before export

Tables overview

Learn how tables work in Databar.

JQ formulas

For JSON-level querying, use JQ expressions.

Getting Started

Core concepts

Databar on other platforms

Account

How it works

How to use

Formula examples

Available formulas

When to use formulas

Tables overview

JQ formulas

​How it works

​How to use

​Formula examples

​Available formulas

​When to use formulas

​Related

Tables overview

JQ formulas

How it works

How to use

Formula examples

Available formulas

When to use formulas

Related