In the math and statistical functions, what are the differences between the ROUND function and the INT function? Give a business example of when you would use each
What will be an ideal response?
The ROUND function rounds a number to the nearest number in the decimal place specified by the num_digits argument. INT always rounds a number down to the nearest integer. Therefore if the direction of the round is not important, and the desired outcome is a whole number, the INT function is appropriate. The ROUND function could be used in a statistical analysis to round currency values to the hundredths place. The INT function could be used to display the number of whole weeks in a given period of time.
Computer Science & Information Technology