INT in SoftMaker PlanMaker: round down to an integer

INT finds the greatest integer less than or equal to a given number, often written mathematically as floor(x). It is useful when a calculation requires complete units, an integer bucket, or a quotient that is rounded down. Because floor means lower on the number line, its handling of negative numbers can surprise anyone expecting simple truncation.

For instance, INT(4.99) is 4, whereas INT(-4.99) is −5. Already-integer inputs remain unchanged: INT(4) is 4 and INT(-4) is −4. Official PlanMaker 2026 INT documentation and the 2024 edition describe this same round-down operation (checked October 13, 2026).

=INT(Number)

The official syntax contains one required input and no optional arguments or defaults. Examples use =INT(B2) where B2 holds a number. Case in the English manual’s argument label is descriptive, not a separate parameter. Always enter formulas with the leading =; PlanMaker formula entry (checked October 13, 2026).

The manual documents the numeric meaning, not every implicit type-conversion rule. Use numeric inputs directly or convert/validate uncertain inputs rather than assuming PlanMaker treats text, empty references, booleans and imported error cells exactly like Excel.

Open a blank worksheet. Place Input in A1, Value in B1 and Floor in C1. Enter the values shown in column B as actual numbers (not text), then enter the formula in the same row of column C.

Type =INT(B2) into C2 and fill the relative formula down through C8 if preferred; the row references should adjust automatically. To check any result without relying on PlanMaker, locate the nearest integer at or below the input on a number line. Positive 7.9 lies above 7 but below 8; negative −7.9 lies above −8 but below −7. These independent arithmetic expectations accord with the official INT definition; they were not observed by executing PlanMaker.

Why negatives differ from simply removing decimal digits

Compare the following mathematical operations on -7.9:

SoftMaker’s 2026 INT and TRUNC references distinguish these operations. The ROUNDDOWN comparison uses the separately documented PlanMaker 2026 ROUNDDOWN function; the example is an independently derived expected result, not a tested formula. Check the linked manual’s exact syntax before copying a related-function formula if documentation changes.

Suppose a shipment contains 31 items, and one full package holds 6 items. Set A10 to 31, B10 to 6, with labels describing their quantities.

=INT(A10/B10)

Independent arithmetic: 31/6 = 5.166666..., so this gives 5 complete packages. To find the leftover items without using a separate remainder function:

=A10-B10*INT(A10/B10)

Expected result: 31 − 6×5 = 1 loose item. This construction is intended for nonnegative item counts and a positive package size. It will give different business meaning when the inputs are negative, and a zero package size is invalid because the quotient is undefined. For a negative adjustment, decide whether floor or truncation is actually appropriate rather than silently treating a negative item count like a physical package quantity.

Use case: inventory carton estimates, number of full batches, and grouping of nonnegative records into fixed-size buckets. Example outcomes are independently calculated.

For a numeric input in B12, the decomposition

=INT(B12)
=B12-INT(B12)

produces an integer floor and the remaining fractional part. For 7.9, expected results are 7 and approximately 0.9. For −7.9, the floor is −8 and the remainder is approximately 0.1, not −0.9. That is because −7.9 = −8 + 0.1. Small floating-point discrepancies are possible in displayed fractions. If the intended meaning is to preserve a negative fractional sign, consider truncation rather than INT. This distinction matters in signed measurements, accounting adjustments and modular arithmetic.

Given numeric measurements in D2:D6, =INT(D2) assigns each value to a width-one bucket with a whole-number label. Inputs −1.2, −0.2, 0, 0.2 and 1.9 yield bucket labels −2, −1, 0, 0 and 1 respectively under mathematical floor. That produces contiguous intervals [k, k+1) for each integer k. This is useful for both positive and negative coordinate systems, including histogram intervals and temperature bands.

A formula such as =INT(D2/5)*5 generalizes to buckets of width five; for D2=−1, the expected bucket start is −5 and for D2=12, the expected start is 10. Negative inputs may create buckets that seem counterintuitive if you expected truncation toward zero. The bucket interpretation is an independent consequence of the documented INT operation, not a native PlanMaker observation.

The underlying reference definition is floor for numeric input. It is not evidence for specific error tokens, array spill behavior, date-serial systems, undocumented string coercions or edge behavior on every edition; these require application tests.

Compatibility assessment: Both PlanMaker and Excel document the same integer-floor meaning and one numeric argument. Native evaluation, imported Excel formulas, formatting, localizations, precise coercion rules and error outcomes were not tested. Do not confuse function-name similarity with end-to-end file compatibility.

• PlanMaker 2026 TRUNC — removes the fractional portion rather than always moving down on the number line.
• PlanMaker 2026 ROUNDDOWN — choose a decimal precision; at zero decimals, compare negative inputs with INT.
• PlanMaker 2026 INT — primary official reference for this tutorial.
• PlanMaker number formatting — display settings and stored values.
• Microsoft Excel INT — separately checked compatibility reference.

Sources checked October 13, 2026: SoftMaker PlanMaker 2026 INT, 2024 INT, 2026 TRUNC, ROUNDDOWN, settings, number-format and formula-entry pages; separate Microsoft Excel INT function reference. PlanMaker executions: 0. Excel executions: 0. Screenshots: 0. Values shown in this guide are independently computed mathematical expectations or official documented examples.