Formualizer Docs
ReferenceFunctionsMath Functions

QUOTIENT

QUOTIENT: Returns the integer portion of a division result, truncated toward zero.

Summary

Returns the integer portion of a division result, truncated toward zero.

Remarks

  • Fractional remainder is discarded without rounding.
  • Dividing by 0 returns #DIV/0!.
  • Input errors are propagated.

Examples

Positive quotient
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Negative quotient truncates toward zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-3

FAQ

How is QUOTIENT different from regular division?

It truncates the fractional part toward zero instead of returning a decimal result.

Runtime metadata

Category

Math

Signature

QUOTIENT(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

POWER

Raises a base number to a specified power.

RADIANS

Converts an angle from degrees to radians.

On this page

SummaryRemarksExamplesRelated functionsFAQHow is QUOTIENT different from regular division?Runtime metadata