Skip to main content

Int()

The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer.  The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.

Fix()

The Fix() and Int() functions both remove the fractional part of a number and returns the restulting integer.  The difference between the two is that if a number is negative Int() returns the first negative integer less than or equal to the number while Fix returns the first negative integer greater than or equal to the numer.

Randomize()

This is used to create a seed value for the Rnd() function, this helps vary the output of the random seed.  You would place a number as the seed, one good option is to use the Second(Now()), this would make sure that your seed is different every time you run the script.

Rnd()

The Rnd() function will calculate a random number between 0 and 1.  You can then multiple it by the top number of the random interval.  So if you wanted a number between 0 and 100 you would multiple it by 100 and also use the Int() function to only capture the integer portion.  In the second example I am looking for a number between 1 and 100, in order to do this I use 99 as the top number and add 1 so that if the random number comes out as 0 it will actually be 1 because I added 1 to it.

Sgn()

This function will return an indicator of the sign.  If the number is negative it returns -1, if positive it returns 1 and if it is 0 it returns 0.  The return value is an integer type.