Numeric functions

 

Top  Previous  Next

Function name:

Usage:

@Abs

@Abs (num) Returns the absolute value of a number.

@Add

@Add (num, num...) Takes a list of numbers and adds them together.  Missing data is not counted.

@Avg

@Avg (num, num ...) Takes any number of values and averages them, ignoring no data.

@Max

@Max (num...) Takes a list of numbers and returns the biggest one.

@Min

@Min (num...) Takes a list of numbers and returns the smallest one.

@Number

@Number (Str) Returns the number stored in the string, str.  Returns 0 if the string is not a number.

@Sqr

@Sqr(num) Returns the square of the given num.

@String

@String(number, numtrail) Converts a number to a string, numtrail is the number of trailing spaces to use.