Question

which function returns to the rounded number to the next lowest integer value​

Answer 1

Answer:

The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative). The Excel ROUND function returns a number rounded to a given number of digits.

Answer 2

Answer:

The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note that negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8)