Functions
Using Calculations 215
Replicate text Replicate: repeats a str for num times Replicate(str, num)
Right text Right: returns characters for str beginning from
the right and proceeding to the left for num
characters
Right(str, num characters)
Round mathematical Round: returns the value of num rounded to the
specified num of decimal places
Round(num, num of decimal
places)
Second time Second: returns the second for a given time Second(time)
Sign mathematical Sign: returns the sign of num. A positive num
returns 1, zero returns 0, and a negative num
returns -1.
Sign(num)
Sqrt mathematical Square Root: returns the square root of a
positive number
Sqrt(num)
Sum statistical Sum: returns the total of num1, num2, and so
forth
Sum(num1, num2, ...)
Time time Time: returns the current time as HH:MM:SS
based on the current system clock
Time()
Trim text Trim: removes leading, trailing spaces, and all
other extra spaces from str.
Trim(str)
Trunc mathematical Truncate: returns the value of num truncated
down to the specified num of decimal place
Trunc(num, num of decimal
places)
Upper text Upper: converts str to uppercase Upper(str)
Year date Year: returns the year number for a given date Year(date)
To Next Page
Loading...
Need help?
General
