Round()
The round function will return a specified value to the nearest number, the default value is to the nearest 0, if you wish to the nearest decimal point the function would be Round(number, numer of decimals). I haven't found a way to round to the nearest tenths or more (one way to get around this is first divide your number by 10, assuming you want to round to the nearest tenths, them do the default round and finally multiply by 10, see the last example). Also the return value is the same type as the value that is being rounded, so if the number is a double the return value is a
- Read more about Round()
- Log in or register to post comments
Log()
This function calculates the natural log (base e) of the specified number. The value that is returned is of a type double. To see an example of how to calculate the log of a base 10 see the snippets section.
- Read more about Log()
- 2 comments
- Log in or register to post comments
Exp()
Returns a number containing the base of a natural logarithm (e) raised to the specified power. The return value is a double type.
- Read more about Exp()
- Log in or register to post comments
Cos()
Calculates the cosine of a specified angle. It returns a double value.
- Read more about Cos()
- Log in or register to post comments
Atn()
Calculates the value containing the angle whose tangent is the specified number. The result is a double type. The example below calculates pi.
- Read more about Atn()
- Log in or register to post comments
Abs()
Returns the absolute value of a specified number.
- Read more about Abs()
- 2 comments
- Log in or register to post comments
Remove Blanks from an Array
This function will remove any blank elements within an array.
- Read more about Remove Blanks from an Array
- Log in or register to post comments
How to sort an array
Somteimes you need to be able to sort an array. This function will take a single array and sort it in alphabetical order.
- Read more about How to sort an array
- 7 comments
- Log in or register to post comments
2nd - 3rd - 4th digit test
This script will perform the 2nd, 3rd and 4th digit test which is based on Benford's Law. The test is based on Mark J. Nigrini's book Benford's Law Applications for Forensic Accounting, Auditing, and Fraud Detection. The script will create one file for each digit test.
Feb 14, 2013 - Updated for IDEA v9.
- Read more about 2nd - 3rd - 4th digit test
- Log in or register to post comments
Log10
This function will return a Log10 value
- Read more about Log10
- Log in or register to post comments