Arguments can be numbers or cell references. A cell reference can be a single cell or a range of cells. A single cell can use relative addressing (A1) or absolute addressing ($B$5). A range of cells is specified by a pair of diagonal cells (A1:C5 or $A$1:$C:$5). Different functions have difference requirements on the number or type of parameters.
The structure of a function begins with the an equal sign (=), the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.
=FUNCTION(ARGUMENT1,ARGUMENT2,...)
Sharp Tools Spreadsheet implements various symbolic formula operations:
usage: =ABS(argument)
Returns the absolute value of is argument.
Example: =ABS(-1) returns 1.
usage: =AVERAGE(argument1,argument2,...)
Returns the average (arithmetic mean) of its arguments.
usage: =COUNT(argument1,argument2,...)
Returns the number of its arguments.
Example: =COUNT(A1:A25,B1) returns 26.0.
usage: =E()
Returns an approximation of the golden mean. Takes no arguments.
Example: =E() returns 2.7182817
usage: =INT(argument)
Returns the integer portion of its argument.
Example: =INT(94.99) returns 94.0.
usage: =LOG(argument)
Returns the logarithm base e of its argument.
Example: =LOG(E()*E()) returns 2.0.
usage: =MAX(argument1,argument2,...)
Returns the largest number among its arguments.
Example:=MAX(99.99,100,99.9999) returns 100.0.
usage: =MEANDEV(argument1,argument2,...)
Returns the largest average absolute deviation of its arguments.
usage: =MEANDEV(argument1,argument2,...)
Returns the largest average absolute deviation of its arguments.
usage: =MIN(argument1,argument2,...)
Returns the largest average absolute deviation of its arguments.
usage: =PI()
Returns an approximation of pi. Takes no arguments.
usage: =RANGE(argument1,argument2,...)
Returns the difference between MAX and MIN of its arguments.
usage: =ROUND(argument)
Returns the nearest integer value of its argument.
usage: =SQRT(argument)
Returns the square root of its argument.
usage: =SUM(argument1,argument2,...)
Adds up the specified arguments.
usage: =STDDEV(argument1,argument2,...)
Returns the standard deviation of its arguments.
TRIG can be any one of the trigonometric functions SIN, COS, TAN, ASIN, ACOS, or ATAN. All trigonometric functions take only one parameter input, which is specified in radians.
usage: =TRIG(argument)
Example: =COS(2*PI()) returns 1.0.