WHOLE and SELECT functions in Excel

Contents

This example illustrates two functions for dropping the decimal part of a number in Excel: INT (INTEGER) and TRUNC (OTBR).

WHOLE

Function INT (INTEGER) rounds a number to the nearest whole number.

=INT(A1)

=ЦЕЛОЕ(A1)

Function INT (INTEGER) discards the decimal part of only a positive number. Negative values are rounded down to the smallest integer.

Function TRUNC (SELECT) always discards the characters to the right of the comma.

=TRUNK(A1,0)

=ОТБР(A1;0)

Function TRUNC (SELECT) can leave the required number of decimal places, discarding the rest.

=TRUNK(A1,2)

=ОТБР(A1;2)

=TRUNK(A1,3)

=ОТБР(A1;3)