These functions perform mathematical operations on numeric values, and return the result. You can use these to make calculations in imports, reports, or models.
Returns the arccosine, or inverse cosine, of a given number.
This function is useful for performing trigonometric calculations in statistical or mathematical models, such as forecasting or engineering-based metrics
ACOS(data)
Example:
ACOS(-0.5) = 2.094395
Returns the inverse hyperbolic cosine of a given number.
This function is useful for specialized scientific or financial models that involve exponential growth patterns or transformation of skewed data
ACOSH(data)
Example:
ACOSH(10) = 2.993222
Returns the arcsine, or inverse sine, of a given number.
This function is useful for advanced analytical modeling where trigonometric transformations are required.
ASIN(data)
Example:
ASIN(-0.5) = -0.523599
Returns the inverse hyperbolic sine of a given number.
This function is useful for working with data sets that require transformation of non-linear growth values or normalization in risk models.
ASINH(data)
Example:
ASINH(10) = 2.998223
Returns the arctangent, or inverse tangent, of a given number.
This function is useful for calculations involving angles or slopes, which is occasionally used in financial simulations with vector modeling.
ATAN(data)
Example:
ATAN(1) = 0.785398
Returns the arctangent, or inverse tangent, of the given coordinates.
This function is useful for determining direction or slope in two-dimensional financial geometry or risk surfaces.
ATAN2(data, number)
Example:
ATAN2(1, 1) = 0.785398
Returns the inverse hyperbolic tangent of a given number.
This function is useful for transformations in certain econometric or physics-based financial models.
ATANH(data)
Example:
ATANH(-0.1) = -0.100335
Returns the cosine of a given number.
This function is useful for cycle analysis such as market timing, waves, or economic seasonality modeling.
COS(data)
Example:
COS(1.047) = 0.500171
Returns the hyperbolic cosine of a given number.
This function is useful for advanced calculations involving exponential change or risk gradients.
COSH(data)
Example:
COSH(4) = 27.308233
Returns the result of converting radians to degrees.
This function is useful for translating angle-based outputs into standard degree formats, often needed in engineering-influenced models.
DEGREES(data)
Example:
DEGREES(3) = 171.887339
Returns e raised to the power of a given number. The inverse of the EXP function is LN.
This function is useful for modeling continuous growth such as compound interest, investment value, or natural growth in projections.
EXP(data)
Example:
EXP(1) = 2.718282
Returns the factorial of a given number.
This function is useful for permutations, combinations, and probabilistic models in forecasting or scenario planning.
FACT(data)
Example:
FACT(5) = 120
Returns the natural logarithm of a given number. LN is the inverse of the EXP function.
This function is useful for log-transforming financial series to stabilize variance or normalize skewed distributions.
LN(data)
Example:
LN(86) = 4.454347
Returns the natural logarithm of 10. No parameters are required.
This function is useful for benchmarking or base-change conversions when working with log-transformed financial models.
LN10()
Example:
LN10() = 2.302585
Returns the logarithm of a number to a specified base.
This function is useful for converting growth rates or interpreting exponential scales in investment returns.
LOG(data, base)
Example:
LOG(8, 2) = 3
Returns the base-10 logarithm of a given number.
This function is useful for simplifying ratios or modeling in decibel or magnitude-based financial calculations.
LOG10(data)
Example:
LOG10(86) = 1.934498
Returns the median of numeric values in the given cell range or data array. You can specifiy multiple ranges.
This function is useful for finding the central tendency of performance indicators, expenses, or sales distributions.
MEDIAN(data, data, ..)
Example:
MEDIAN(3, 4, 5, 6, 7) = 5
Returns the remainder from a division between two given numbers.
This function is useful for periodic segmentation, scheduling, or alternate pattern logic in financial timelines.
MOD(data, number)
Example:
MOD(3, 2) = 1
Returns the most frequently occurring value in the given cell range or data array. You can specifiy multiple ranges.
This function is useful for identifying common transaction amounts, repeated accounts, or popular sales categories.
MODE(data, data, ..)
Example:
MODE(3, 4, 4, 5, 6, 7) = 4
Returns the value of PI.
This function is useful for circle-based models or transformations in logistics or supply chain modeling.
PI()
Example:
PI() = 3.141593
Returns the result of a given number raised to a given power.
This function is useful for compounding calculations, exponential growth projections, or weighted scoring models.
POWER(data, number)
Example:
POWER(5, 2) = 25
Returns the integer portion of a division between two given numbers.
This function is useful for floor-based logic like segmenting invoice batches, installment counts, or offset distributions.
QUOTIENT(data, number)
Example:
QUOTIENT(5, 2) = 2
Returns the result of converting degrees to radians.
This function is useful for converting angles to a format needed for trigonometric functions within more technical modeling.
RADIANS(data)
Example:
RADIANS(270) = 4.712389
Returns the sine of a given number.
This function is useful for modeling periodic behavior such as economic cycles or demand fluctuations.
SIN(data)
Example:
SIN(PI()/2) = 1
Returns the hyperbolic sine of a given number.
This function is useful for calculations requiring exponential patterns in advanced simulations or forecasts.
SINH(data)
Example:
SINH(2) = 3.62686
Returns the positive square root of a given number.
This function is useful for volatility, variance, and risk-adjusted return calculations like standard deviation or Sharpe ratio.
SQRT(data)
Example:
SQRT(16) = 4
Calculates the standard deviation based on all values in the given cell range or data array. You can specifiy multiple ranges.
This function is useful for measuring financial volatility, consistency of KPIs, or performance dispersion
STDEVP(data, data, ..)
Example:
=STDEVP(3, 4, 5, 6, 7) = 1.414214
Returns the tangent of a given number.
This function is useful for angle calculations in geometry-based financial modeling or simulations.
TAN(data)
Example:
TAN(0.785) = 0.999204
Returns the hyperbolic tangent of a given number.
This function is useful for advanced regression models or smoothing out risk patterns in statistical projections.
TANH(data)
Example:
TANH(2) = 0.964028
Calculates the variance based on all values in the given cell range or data array. You can specifiy multiple ranges.
This function is useful for quantifying risk, spread, or uncertainty in budgets, forecasts, or investment scenarios.
VARP(data, data, ..)
Example:
VARP(3, 4, 5, 6, 7) = 2