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:
You can also use COUNT with more than one range, such as this:
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 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:
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