=INT(number)

Zoho’s INT help article demonstrates =INT(2.3) → 2, =INT(4.66) → 4 and =INT(-11.2) → -12. In mathematical notation, INT(x) is the floor of x. The argument can be a cell reference; use a genuinely numeric cell so that import parsing does not determine the result unpredictably.

The vendor article does not identify a minimum Zoho version or prove parity across all current and historical clients. This guide documents the formula notation in Zoho’s public help, not native deployment support for each platform.

Paste the included math-sign-and-rounding-practice.csv at A1, keeping B as numeric decimal variances. Row 2 is deliberately negative and row 4 is exact zero; row 8 is a tiny negative value that reveals an important edge case. The relevant B-column values are:

Step-by-step worksheet formula

1. Put Lower integer in E1.
2. In E2 type =INT(B2). Predict -15 before looking at the result.
3. Copy E2 to E3:E9. The row references should change to B3, B4 and so on.
4. Confirm that E5 corresponds to -4, not -3, because the original -3.60 is less than -3.
5. Check E8: although B8 may display -0.04 or even -0.0 under a coarse format, any negative fraction strictly between -1 and 0 floors to -1.
6. Use the sheet’s Number formatting if you prefer no decimal digits in the output; INT itself returns an integer numeric value.

The difference between INT and conventional rounding appears even for positives: INT(8.99) is still 8, not 9. INT never selects the closest integer; it chooses the next integer toward negative infinity (or the number itself if already integral).

Suppose readings are assigned to 5-unit bins that begin at multiples of 5. Put the signed reading in B2, then enter:

=INT(B2/5)*5

For B2 = -14.75, the calculation is INT(-2.95)*5 = -3*5 = -15, so the bin starts at -15. For B3 = 8.20, the same formula gives 5. For B5 = -3.60, the lower multiple is -5, not 0. This is particularly useful when negative adjustments must occupy distinct lower-bound buckets.

For a configurable positive bucket width, enter 5 in H1 and use:

=IF($H$1>0;INT(B2/$H$1)*$H$1;"Invalid width")

The intended output is -15 for B2 and width 5. The width must be positive for the stated bucket interpretation; zero would otherwise cause division by zero. This combined IF and INT expression is an unexecuted formula proposal and should be tested inside Zoho before production use.

INT also explains the documented MOD formula. For MOD(-23;5), INT(-23/5) = -5. Therefore the remainder is -23 - 5*(-5) = 2. Replacing INT with truncation toward zero would break Zoho’s documented divisor-sign convention.

These are independent expected numerical results from the documented definitions, not a paired screenshot of native Zoho outputs. ROUND uses a different rule to choose a nearest value; see the existing ROUND review proposal for a separate explanation. For simply hiding decimal digits while retaining a value, change number formatting rather than calling INT or TRUNC.

Zoho includes generic function errors, such as #N/A!, in its shared reference template; INT is not a lookup function. The right diagnosis depends on the actual formula and input type.

Microsoft’s Excel INT reference explicitly confirms that INT(-8.9) → -9, the same mathematical floor behavior documented by Zoho. Both Excel and Google Sheets have similarly named functions, but this statement is not evidence that blank values, imported text, arrays and locale settings match on every platform. The function’s own one-argument syntax is simple; composite IF formulas in this guide use Zoho’s published semicolon style, whereas English-language Excel examples often use commas.

• Zoho Sheet — function documentation

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.