INT What is it?

[Guest_imported]

I recently did a wage calc and asked a few people how to round up numbers and they told me to use the INT function but what does it stand for and Do?

 

[dpaulson]

Int stands for integer part, so int(6.7) will result in 6
David Paulson

 

[froothed]

you can use cint to round to nearest:
cint(1.4) = 1
cint(1.5) = 2

 

[ErezSh]

INT will always return the lowest integer value.
exmaple: INT(10.9)=10 , INT(-10.9)=-11
FIX will always return the integer part.
example: FIX(10.9)=10 , FIX(-10.9)=-10
CINT will round up the number to the closest integer value.
example: CINT(10.9)=11 , CINT(-10.4)=-10 Cheers
Erez Sh.