This is your complete guide to every formula function available in TexAu. Each function includes a description, syntax, practical examples with expected input and output, and tips for getting the most out of it.
Use this page as a reference whenever you are building or troubleshooting a formula.
Logic functions
Logic functions let you make decisions in your formulas. Use them to categorize data, check conditions, and handle missing values.
IF —conditional logic
What it does: Returns one value when a condition is true and a different value when it is false.
Syntax:
IF(condition, value_if_true, value_if_false)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| condition | An expression that evaluates to true or false |
| value_if_true | The value returned when the condition is true |
| value_if_false | The value returned when the condition is false |
Examples:
- Categorize companies by employee count:
IF(employee_count > 500, "Enterprise", "Mid-Market")
This table scrolls sideways on small screens.
| employee_count | Result |
|---|---|
| 1200 | Enterprise |
| 85 | Mid-Market |
- Flag high-value deals for your sales team:
IF(deal_value > 50000, "High Priority", "Standard")
This table scrolls sideways on small screens.
| deal_value | Result |
|---|---|
| 75000 | High Priority |
| 12000 | Standard |
- Nested IF for multi-tier classification:
IF(revenue > 1000000, "Tier 1", IF(revenue > 100000, "Tier 2", "Tier 3"))
This table scrolls sideways on small screens.
| revenue | Result |
|---|---|
| 2500000 | Tier 1 |
| 350000 | Tier 2 |
| 45000 | Tier 3 |
Tips:
- You can nest IF functions up to 5 levels deep for multi-tier logic.
- Conditions use comparison operators such as
>,<,==,!=,>=, and<=. - Think of it as: "If this is true, do A. Otherwise, do B."
AND —all conditions must be true
What it does: Returns true only when every condition you provide is met.
Syntax:
AND(condition1, condition2, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| condition1, condition2, ... | Two or more expressions that each evaluate to true or false |
Examples:
- Identify qualified leads based on multiple criteria:
AND(industry == "Technology", revenue > 100000, hiring == true)
This table scrolls sideways on small screens.
| industry | revenue | hiring | Result |
|---|---|---|---|
| Technology | 250000 | true | true |
| Technology | 50000 | true | false |
| Healthcare | 300000 | true | false |
- Check that key fields are filled in:
AND(email != "", phone != "", company != "")
This table scrolls sideways on small screens.
| phone | company | Result | |
|---|---|---|---|
| john@acme.com | 5551234567 | Acme | true |
| john@acme.com | Acme | false |
- Combine with IF for actionable output:
IF(AND(status == "active", plan == "enterprise"), "Renewal Candidate", "Other")
Tips:
- AND is strict —every condition must pass for the result to be true.
- Pair with IF to take action when multiple criteria are met at once.
- Commonly used for data quality checks and lead qualification.
OR —at least one condition must be true
What it does: Returns true when any one of the conditions you provide is met.
Syntax:
OR(condition1, condition2, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| condition1, condition2, ... | Two or more expressions that each evaluate to true or false |
Examples:
- Identify executive-level contacts:
OR(title == "CEO", title == "CTO", title == "CFO")
This table scrolls sideways on small screens.
| title | Result |
|---|---|
| CEO | true |
| Sales Manager | false |
| CFO | true |
- Check for target industries:
OR(industry == "SaaS", industry == "FinTech", industry == "Healthcare")
- Flag incomplete records:
IF(OR(email == "", phone == ""), "Incomplete", "Complete")
This table scrolls sideways on small screens.
| phone | Result | |
|---|---|---|
| john@acme.com | 5551234567 | Complete |
| 5551234567 | Incomplete | |
| john@acme.com | Incomplete |
Tips:
- OR is more permissive than AND —only one condition needs to pass.
- Useful for grouping records into categories (e.g., "Is this a target industry?").
- Combine with IF to produce readable labels based on the result.
NOT —reverse a boolean
What it does: Flips true to false and false to true.
Syntax:
NOT(condition)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| condition | An expression that evaluates to true or false |
Examples:
- Find contacts who are not yet customers:
NOT(is_customer == true)
- Flag unverified leads:
IF(NOT(email_verified), "Needs Verification", "Verified")
This table scrolls sideways on small screens.
| email_verified | Result |
|---|---|
| true | Verified |
| false | Needs Verification |
- Exclude a specific group:
NOT(AND(industry == "Competitor", deal_stage == "Closed"))
Tips:
- NOT is cleaner than writing
condition == false. - Combine with AND and OR for advanced filtering logic.
COALESCE —return the first non-empty value
What it does: Checks a list of values in order and returns the first one that is not empty. This is how you handle missing data gracefully.
Syntax:
COALESCE(value1, value2, value3, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| value1, value2, ... | Two or more values or column references, checked in order |
Examples:
- Build an email waterfall (prefer personal, fall back to work, then backup):
COALESCE(personal_email, work_email, backup_email)
This table scrolls sideways on small screens.
| personal_email | work_email | backup_email | Result |
|---|---|---|---|
| john@gmail.com | john@acme.com | john@backup.com | john@gmail.com |
| sarah@acme.com | sarah@backup.com | sarah@acme.com | |
| mike@backup.com | mike@backup.com |
- Prioritize phone number sources:
COALESCE(mobile_phone, office_phone, home_phone)
- Provide a default when data is missing:
COALESCE(city, "Not Provided")
This table scrolls sideways on small screens.
| city | Result |
|---|---|
| San Francisco | San Francisco |
| Not Provided |
Tips:
- Order matters —COALESCE checks values from left to right and stops at the first non-empty one.
- Great for waterfall enrichment workflows where you have multiple data sources.
- Use a quoted string as the last value to set a fallback default.
Text functions
Text functions let you combine, extract, clean, and transform text data across your columns.
CONCAT —join text together
What it does: Combines multiple text values into a single string.
Syntax:
CONCAT(value1, value2, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| value1, value2, ... | Two or more text values or column references to join |
Examples:
- Create a full name:
CONCAT(first_name, " ", last_name)
This table scrolls sideways on small screens.
| first_name | last_name | Result |
|---|---|---|
| John | Smith | John Smith |
| Sarah | Johnson | Sarah Johnson |
- Build a display label:
CONCAT(first_name, " at ", company_name)
This table scrolls sideways on small screens.
| first_name | company_name | Result |
|---|---|---|
| John | Acme Corp | John at Acme Corp |
- Assemble a full address:
CONCAT(street, ", ", city, ", ", state, " ", zip)
This table scrolls sideways on small screens.
| street | city | state | zip | Result |
|---|---|---|---|---|
| 123 Main St | Denver | CO | 80202 | 123 Main St, Denver, CO 80202 |
Tips:
- Always include separators (spaces, commas, dashes) explicitly —CONCAT does not add them automatically.
- You can join as many values as you need in a single CONCAT call.
- Mix column references with quoted text freely.
LEN —count characters
What it does: Returns the number of characters in a text value, including spaces.
Syntax:
LEN(text)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | A text value or column reference |
Examples:
- Check if a description is substantial:
IF(LEN(company_description) > 100, "Detailed", "Brief")
- Validate email length:
IF(LEN(email) < 5, "Likely Invalid", "Probably Valid")
This table scrolls sideways on small screens.
| LEN(email) | Result | |
|---|---|---|
| john@acme.com | 13 | Probably Valid |
| a@b | 3 | Likely Invalid |
- Verify phone number format:
IF(LEN(phone_number) >= 10, "Valid Format", "Needs Review")
Tips:
- LEN counts every character, including spaces and punctuation.
- Combine with IF for simple data quality checks.
- Useful as a quick validation before sending data to other systems.
UPPER —convert to uppercase
What it does: Converts all letters in a text value to uppercase.
Syntax:
UPPER(text)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | A text value or column reference |
Examples:
- Standardize state abbreviations:
UPPER(state)
This table scrolls sideways on small screens.
| state | Result |
|---|---|
| ca | CA |
| ny | NY |
- Normalize industry labels:
UPPER(industry)
This table scrolls sideways on small screens.
| industry | Result |
|---|---|
| technology | TECHNOLOGY |
| SaaS | SAAS |
Tips:
- UPPER affects letters only —numbers and symbols remain unchanged.
- Useful for standardizing values before comparisons.
- Combine with TRIM to clean and uppercase in one step.
LOWER —convert to lowercase
What it does: Converts all letters in a text value to lowercase.
Syntax:
LOWER(text)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | A text value or column reference |
Examples:
- Standardize email addresses:
LOWER(email)
This table scrolls sideways on small screens.
| Result | |
|---|---|
| John@ACME.com | john@acme.com |
- Normalize domains for matching:
LOWER(domain)
This table scrolls sideways on small screens.
| domain | Result |
|---|---|
| ACME.COM | acme.com |
| Startup.IO | startup.io |
- Case-insensitive comparison:
LOWER(status) == "active"
Tips:
- Often used before comparisons to handle inconsistent data entry.
- Combine with TRIM for thorough data cleanup:
LOWER(TRIM(value)).
TRIM —remove leading and trailing spaces
What it does: Strips extra spaces from the beginning and end of a text value.
Syntax:
TRIM(text)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | A text value or column reference |
Examples:
- Clean up imported company names:
TRIM(company_name)
This table scrolls sideways on small screens.
| company_name | Result |
|---|---|
| " Acme Inc. " | "Acme Inc." |
| " Tech Corp " | "Tech Corp" |
- Standardize before comparison:
TRIM(title) == "Sales Manager"
- Combine with other cleanup functions:
UPPER(TRIM(industry))
Tips:
- TRIM removes spaces from both ends but does not affect spaces in the middle of the text.
- Good for data imported from external sources where formatting is inconsistent.
- Combine with UPPER or LOWER for thorough text standardization.
REPLACE —find and replace text
What it does: Finds all occurrences of a specified text within a string and replaces them with new text.
Syntax:
REPLACE(text, old_text, new_text)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | The original text value or column reference |
| old_text | The text to search for |
| new_text | The text to substitute in its place |
Examples:
- Remove dashes from phone numbers:
REPLACE(phone_number, "-", "")
This table scrolls sideways on small screens.
| phone_number | Result |
|---|---|
| 555-123-4567 | 5551234567 |
- Remove "www." from domains:
REPLACE(domain, "www.", "")
This table scrolls sideways on small screens.
| domain | Result |
|---|---|
| www.acme.com | acme.com |
- Stack REPLACE calls to handle multiple patterns:
REPLACE(REPLACE(phone, "-", ""), " ", "")
This table scrolls sideways on small screens.
| phone | Result |
|---|---|
| 555-123 4567 | 5551234567 |
Tips:
- REPLACE is case-sensitive —"Corp" will not match "corp".
- To handle multiple replacements, nest REPLACE calls inside each other.
- Use an empty string
""as the replacement to delete text.
SPLIT —break text into parts
What it does: Splits a text string into an array of parts using a separator you specify.
Syntax:
SPLIT(text, delimiter)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | The text value or column reference to split |
| delimiter | The character or string to split on |
Examples:
- Extract the domain from an email address:
SPLIT(email, "@")[1]
This table scrolls sideways on small screens.
| Result | |
|---|---|
| john@acme.com | acme.com |
- Get the first word from a job title:
SPLIT(title, " ")[0]
This table scrolls sideways on small screens.
| title | Result |
|---|---|
| Vice President Sales | Vice |
- Parse a structured code:
SPLIT(product_code, "-")[0]
This table scrolls sideways on small screens.
| product_code | Result |
|---|---|
| PROD-2024-001 | PROD |
Tips:
- SPLIT returns an array. Use
[0]for the first part,[1]for the second, and so on. - Indexing starts at 0 (the first piece is
[0]). - Best suited for data that follows a consistent pattern or structure.
SUBSTRING —extract a portion of text
What it does: Returns a specific portion of a text string based on a starting position and length.
Syntax:
SUBSTRING(text, start, length)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | The text value or column reference |
| start | The position to start from (0-based) |
| length | How many characters to extract |
Examples:
- Extract the year from a date string:
SUBSTRING(date_string, 0, 4)
This table scrolls sideways on small screens.
| date_string | Result |
|---|---|
| 2024-01-15 | 2024 |
- Get the first three characters of a company name:
SUBSTRING(company_name, 0, 3)
This table scrolls sideways on small screens.
| company_name | Result |
|---|---|
| Acme Corporation | Acm |
- Extract an area code from a phone number:
SUBSTRING(phone, 0, 3)
This table scrolls sideways on small screens.
| phone | Result |
|---|---|
| 5551234567 | 555 |
Tips:
- Position counting starts at 0, not 1.
- Best for data in fixed formats where you know the exact position of the information you need.
- For variable-format data, consider SPLIT or AFTER instead.
AFTER —get everything after a delimiter
What it does: Returns all text that appears after the first occurrence of a specified delimiter.
Syntax:
AFTER(text, delimiter)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| text | The text value or column reference |
| delimiter | The character or string to search for |
Examples:
- Extract domain from an email address:
AFTER(email, "@")
This table scrolls sideways on small screens.
| Result | |
|---|---|
| john@acme.com | acme.com |
| sarah@startup.io | startup.io |
- Get the path from a URL:
AFTER(url, "//")
This table scrolls sideways on small screens.
| url | Result |
|---|---|
https://acme.com/about | acme.com/about |
- Extract the value after a separator:
AFTER(employee_code, "-")
This table scrolls sideways on small screens.
| employee_code | Result |
|---|---|
| DEPT-ABC123 | ABC123 |
Tips:
- The delimiter itself is not included in the result.
- Simpler than SPLIT when you only need the text after a single separator.
- If the delimiter is not found in the text, the original text is returned unchanged.
Math functions
Math functions let you perform calculations, round values, and work with numbers in your formulas.
ABS —absolute value
What it does: Returns the positive version of a number, removing any negative sign.
Syntax:
ABS(number)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number | A numeric value or column reference |
Examples:
- Show variance magnitude regardless of direction:
ABS(revenue_variance)
This table scrolls sideways on small screens.
| revenue_variance | Result |
|---|---|
| -5000 | 5000 |
| 3200 | 3200 |
- Calculate how far actual results deviate from target:
ABS(target_revenue - actual_revenue)
This table scrolls sideways on small screens.
| target_revenue | actual_revenue | Result |
|---|---|---|
| 100000 | 85000 | 15000 |
| 100000 | 112000 | 12000 |
Tips:
- ABS is useful when you care about the size of a difference, not its direction.
- Common in performance tracking and variance analysis.
MIN —smallest value
What it does: Returns the smallest number from the values you provide.
Syntax:
MIN(number1, number2, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number1, number2, ... | Two or more numeric values or column references |
Examples:
- Find the lowest vendor quote:
MIN(vendor_a_price, vendor_b_price, vendor_c_price)
This table scrolls sideways on small screens.
| vendor_a_price | vendor_b_price | vendor_c_price | Result |
|---|---|---|---|
| 4500 | 3200 | 5100 | 3200 |
- Find the fastest delivery option:
MIN(standard_days, express_days, overnight_days)
This table scrolls sideways on small screens.
| standard_days | express_days | overnight_days | Result |
|---|---|---|---|
| 7 | 3 | 1 | 1 |
- Make sure a value never drops below zero:
MAX(profit, 0)
Tips:
- MIN compares numeric values only.
- Useful for finding the best (lowest cost, shortest time) option across multiple sources.
MAX —largest value
What it does: Returns the largest number from the values you provide.
Syntax:
MAX(number1, number2, ...)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number1, number2, ... | Two or more numeric values or column references |
Examples:
- Find the best-performing quarter:
MAX(q1_revenue, q2_revenue, q3_revenue, q4_revenue)
This table scrolls sideways on small screens.
| q1_revenue | q2_revenue | q3_revenue | q4_revenue | Result |
|---|---|---|---|---|
| 120000 | 95000 | 145000 | 110000 | 145000 |
- Find the highest lead score across categories:
MAX(engagement_score, fit_score, activity_score)
This table scrolls sideways on small screens.
| engagement_score | fit_score | activity_score | Result |
|---|---|---|---|
| 72 | 88 | 65 | 88 |
- Cap a value at a maximum (use MIN for this):
MIN(quota_attainment, 1.5)
Tips:
- MAX returns the single highest value.
- Pair with MIN for range analysis:
MAX(a, b) - MIN(a, b)gives the spread.
ROUND —round to decimal places
What it does: Rounds a number to the number of decimal places you specify.
Syntax:
ROUND(number, decimals)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number | A numeric value or column reference |
| decimals | How many decimal places to keep (0 for whole numbers) |
Examples:
- Round to the nearest whole dollar:
ROUND(monthly_cost, 0)
This table scrolls sideways on small screens.
| monthly_cost | Result |
|---|---|
| 123.456 | 123 |
| 89.72 | 90 |
- Round a percentage to two decimal places:
ROUND(percentage, 2)
This table scrolls sideways on small screens.
| percentage | Result |
|---|---|
| 75.6789 | 75.68 |
- Calculate and round a monthly cost:
ROUND(annual_cost / 12, 2)
This table scrolls sideways on small screens.
| annual_cost | Result |
|---|---|
| 15000 | 1250.00 |
Tips:
- Use 0 for whole numbers, 2 for currency values.
- Standard rounding rules apply (0.5 rounds up).
FLOOR —always round down
What it does: Rounds a number down to the nearest whole number, regardless of the decimal value.
Syntax:
FLOOR(number)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number | A numeric value or column reference |
Examples:
- Calculate complete years from days:
FLOOR(days_as_customer / 365)
This table scrolls sideways on small screens.
| days_as_customer | Calculation | Result |
|---|---|---|
| 1463 | 4.01 | 4 |
| 200 | 0.55 | 0 |
- Calculate full months of tenure:
FLOOR(tenure_in_days / 30)
This table scrolls sideways on small screens.
| tenure_in_days | Result |
|---|---|
| 127 | 4 |
Tips:
- FLOOR always rounds down, even if the decimal is .99.
- Useful when you only want to count complete units (full years, full months, full dozens).
- Opposite of CEIL.
CEIL —always round up
What it does: Rounds a number up to the nearest whole number, regardless of the decimal value.
Syntax:
CEIL(number)
Parameters:
This table scrolls sideways on small screens.
| Parameter | Description |
|---|---|
| number | A numeric value or column reference |
Examples:
- Calculate billable hours (always round up partial hours):
CEIL(task_minutes / 60)
This table scrolls sideways on small screens.
| task_minutes | Calculation | Result |
|---|---|---|
| 65 | 1.08 | 2 |
| 120 | 2.00 | 2 |
- Calculate the number of pages needed:
CEIL(total_words / 500)
This table scrolls sideways on small screens.
| total_words | Result |
|---|---|
| 2400 | 5 |
- Determine how many groups of five you need:
CEIL(employees / 5)
This table scrolls sideways on small screens.
| employees | Result |
|---|---|
| 23 | 5 |
Tips:
- CEIL always rounds up, even if the decimal is .01.
- Useful for "you need at least this many" calculations (seats, pages, hours).
- Opposite of FLOOR.
Combining functions: real-world recipes
You get the most out of formulas when you combine multiple functions. Here are recipes you can adapt for common B2B data tasks.
Clean and standardize a domain from an email
LOWER(TRIM(AFTER(email, "@")))
What it does: Extracts the domain, removes any stray spaces, and converts to lowercase for consistent matching.
This table scrolls sideways on small screens.
| Result | |
|---|---|
| John@ACME.COM | acme.com |
| " sarah@Startup.IO " | startup.io |
Categorize leads by multiple criteria
IF(AND(revenue > 500000, employee_count > 200), "Enterprise",
IF(AND(revenue > 100000, employee_count > 50), "Mid-Market", "SMB"))
What it does: Assigns a segment label based on both revenue and team size thresholds.
This table scrolls sideways on small screens.
| revenue | employee_count | Result |
|---|---|---|
| 800000 | 350 | Enterprise |
| 250000 | 80 | Mid-Market |
| 50000 | 15 | SMB |
Build a personalized greeting
CONCAT("Hi ", first_name, ", I noticed ", company_name, " is growing in ", industry, ".")
What it does: Creates a personalized outreach opening line from your table data.
This table scrolls sideways on small screens.
| first_name | company_name | industry | Result |
|---|---|---|---|
| Sarah | Acme Corp | SaaS | Hi Sarah, I noticed Acme Corp is growing in SaaS. |
Find the best available contact method
IF(COALESCE(mobile_phone, "") != "", "Call Mobile",
IF(COALESCE(work_email, "") != "", "Send Email", "No Contact Available"))
What it does: Determines the best way to reach a contact based on available data.
This table scrolls sideways on small screens.
| mobile_phone | work_email | Result |
|---|---|---|
| 5551234567 | john@acme.com | Call Mobile |
| sarah@acme.com | Send Email | |
| No Contact Available |
Calculate and format a monthly cost
CONCAT("$", ROUND(annual_cost / 12, 2), "/month")
What it does: Converts an annual cost to monthly, rounds to two decimal places, and formats with a dollar sign.
This table scrolls sideways on small screens.
| annual_cost | Result |
|---|---|
| 15000 | $1250/month |
| 8400 | $700/month |
Score and label data quality
IF(AND(LEN(email) > 5, LEN(phone) >= 10, company != ""), "Complete",
IF(OR(email != "", phone != ""), "Partial", "Missing"))
What it does: Rates each record's data completeness based on the presence and format of key fields.
This table scrolls sideways on small screens.
| phone | company | Result | |
|---|---|---|---|
| john@acme.com | 5551234567 | Acme | Complete |
| john@acme.com | Partial | ||
| Missing |
Quick function finder
This table scrolls sideways on small screens.
| I need to... | Use this function |
|---|---|
| Make a decision based on a condition | IF |
| Check that all conditions are met | AND |
| Check that at least one condition is met | OR |
| Reverse a true/false value | NOT |
| Get the first non-empty value from a list | COALESCE |
| Combine text from multiple columns | CONCAT |
| Count characters in a text field | LEN |
| Convert text to uppercase | UPPER |
| Convert text to lowercase | LOWER |
| Remove leading and trailing spaces | TRIM |
| Find and replace text | REPLACE |
| Break text apart by a separator | SPLIT |
| Extract a fixed-length portion of text | SUBSTRING |
| Get everything after a separator | AFTER |
| Check if text contains a keyword | INCLUDES |
| Get the absolute value of a number | ABS |
| Find the smallest number | MIN |
| Find the largest number | MAX |
| Round to a specific number of decimals | ROUND |
| Always round down | FLOOR |
| Always round up | CEIL |
Next steps
- Formula Basics —Review the fundamentals of writing formulas, referencing columns, and using operators.
- Built-in Processing Actions —Pre-built data transformation tools that work alongside your formulas.
- Setting Up Scheduled Jobs —Automate your workflows to run on a schedule.