AXEL Math Functions

← Back to Overview

🔢 Mathematical Operations

6 essential functions for mathematical calculations.

ABS

Get absolute value (remove negative sign).

ABS(-123.45)

Returns: 123.45
Use Cases: Distance calculations, magnitude analysis

SQRT

Calculate square root.

SQRT(144)

Returns: 12
Use Cases: Statistical calculations, geometric means

ROUND

Round to specified decimal places.

ROUND(123.456, 2)

Returns: 123.46
Use Cases: Currency formatting, precision control

ROUNDUP

Always round up (ceiling).

ROUNDUP(123.123, 1)

Returns: 123.2
Use Cases: Conservative estimates, minimum thresholds

ROUNDDOWN

Always round down (floor).

ROUNDDOWN(123.789, 1)

Returns: 123.7
Use Cases: Maximum thresholds, floor calculations

DIVIDE

Safe division with error handling.

DIVIDE(100, 3, 0)

Special: Returns third parameter if division by zero
Returns: 33.33... or 0 if error
Use Cases: Ratio calculations, percentage formulas

💡 Practical Examples

Calculate Percentage

DIVIDE([Part], [Whole], 0) * 100

Standard Deviation (Manual)

SQRT(
    AVERAGEX(
        [Table],
        ([Value] - [Average]) * ([Value] - [Average])
    )
)

Round to Nearest 5

ROUND([Value] / 5, 0) * 5

Safe Average Calculation

DIVIDE(
    SUM([Values]),
    COUNT([Values]),
    0
)

📊 Common Patterns

Financial Rounding

ROUND([Amount], 2)  -- Standard currency
ROUNDUP([Tax], 2)   -- Conservative tax calculation

Statistical Calculations

ABS([Value] - [Mean])  -- Absolute deviation
SQRT([Variance])       -- Standard deviation

Growth Rate

DIVIDE(
    [NewValue] - [OldValue],
    ABS([OldValue]),
    0
)

Next: Text Functions →