The list below show's the most common Math and related functions that a normal user would used and as follows;
I want also to specifically mention three(3) of these functions: FORMAT(), ROUND(), RAND(). The 1st - which is not technically number-specific, it turns any number into a more conventionally formatted layout. For example, If you stored the cost of a car as 20198.20, then Format(car_cost, 2) would turn that number into the more common 20,198.20.
Function
| Usage
| ABS() - returns the absolute value of column
| ABS(column)
| CEILING() - returns the next-highest integer based upon the value of column
| Ceiling(column)
| FLOOR() - returns the integer value of column
| Floor(column)
| MOD() - returns the remainder of dividing x by y (either or both can be a column)
| MOD(x, y)
| RAND() - returns a random number between 0 and 1.0.
| RAND()
| ROUND() - returns the number x rounded to y decimal places
| Round(x, y)
| SIGN() - returns a value indicating whether a number is negative(-1), zero(0), or positive(+1)
| Sign(column)
|
|
