Microsoft Office Tutorials and References

In Depth Information

**INT and ROUND**

=COUNT(cell reference 1, cell reference 2,...)

You can also use COUNT with a range, as shown here:

=COUNT(A1:A12)

You can also use COUNT with more than one range, such as this:

=COUNT(A1:A12, B1:B12)

INT and ROUND

The INT and ROUND functions both work by removing or reducing a

number’s decimal portion. They differ in exactly
how
they remove it.

INT

INT simply drops the decimal portion without rounding — that is, without

regard to whether the number is closer to the next higher integer or the next

lower integer. Be aware that INT always truncates to the next lower integer.

For example, INT changes 12.05 to 12, but it also changes 12.95 to 12. Also,

INT changes both –5.1 and –5.9 to –6, not to –5, because –6 is the next lower

integer. INT takes but the single number argument. The syntax follows:

=INT(number)

ROUND

On the other hand, the ROUND function lets you control how the decimal

portion is handled. ROUND takes two arguments — the number to be

manipulated and the number of decimal places to round to. This gives you more

control. A number such as 5.6284 can become 5.628, 5.63, 5.6, or just 6. ROUND

always rounds up or down to the nearest number of the next significant digit,

so 5.628 becomes 5.63, not 5.62.

ROUND turns 12.95 into either 12.9 or 13, depending on the setting of the

second argument. Note that there are two functions — ROUNDUP and

ROUNDDOWN — that round in one direction only. The syntax for ROUND

follows: