Skip to main content

Number Functions

Number functions allow you to perform calculations, formatting, and conversions on numeric values.

ABS(A)​

Returns the absolute value of A.

ABS( quantity )

MAX(A, B, ...)​

Returns the maximum value from the provided values.

MAX( price1, price2, price3 )

MIN(A, B, ...)​

Returns the minimum value from the provided values.

MIN( price1, price2, price3 )

NUM(N, D)​

Formats number N with D digits.

  • pads with leading zeroes
NUM( index, 4 )

NUM(N, D, P)​

Formats number N with:

  • D digits
  • P decimal places

Pads with leading and trailing zeroes.

NUM( quantity, 0, 2 )

CURR(N, D)​

Formats currency value N with D digits.

  • pads with leading zeroes
CURR( quantity, 4 )

CURR(N, D, P)​

Formats currency value N with:

  • D digits
  • P decimal places

Pads with leading and trailing zeroes.

CURR( price, 0, 2 )

TO_NUMBER(T)​

Converts text T to a number.

TO_NUMBER( text )

ROUND(D, S)​

Rounds number D to S decimal places.

  • uses standard rounding (half up)
ROUND( quantity * price, 2 )

ROUNDUP(D, S)​

Rounds number D up to S decimal places.

ROUNDUP( quantity * price, 2 )

ROUNDDOWN(D, S)​

Rounds number D down to S decimal places.

ROUNDDOWN( quantity * price, 2 )

CEILING(D)​

Rounds number D towards positive infinity.

  • positive values → rounded up
  • negative values → rounded down
CEILING( number )

FLOOR(D)​

Rounds number D towards the nearest lower value.

FLOOR( number )

PMT(R, M, PV, [FV, [T]])​

Calculates the payment for a loan based on constant payments and a constant interest rate.

Parameters:

  • R — interest rate
  • M — number of periods
  • PV — present value
  • FV — future value (optional)
  • T — payment timing (optional)
    • true → payment at the beginning of the period
    • false → payment at the end of the period
PMT( rate, 12, 1000 )

Was this article helpful?

Yes
No