Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Excel int function
Excel int function
be good at

meaning

Rounds the value up or down to the nearest integer.

grammar

INT (number)

Number is a real number that needs to be rounded down or up.

explain

The Int function can be replaced by the floor function.

Int (number) =floor (number, 1)

example

It may be easier to understand if you copy the example into a blank worksheet.

In C/C++

In the 32/64-bit system, there are 32 bits, ranging from-2147483648 ~+2147483647, which is expressed as 0~4294967295 under unsigned conditions.

Matlab is at

Int is used for symbol ∫.

Indefinite integral of int(s) symbolic expression s 。

On indefinite integral of int(s, v) symbolic expression s of variable v

The definite integral of the symbolic expression S of int(s, a, b), where a and b are the lower and upper limits of the integral respectively.

The definite integral of int(s, v, a, b) symbolic expression s about variable v from a to b 。

When int can't find the symbolic solution, it will automatically turn to the numerical solution.