C1Binding Expression Syntax Elements
The C1Binding class uses the C1CalcEngine class to parse and evaluate expressions. The syntax elements described below apply to both classes.
Case
All expressions are case-insensitive.
Operators
Expressions may contain the following operators:
| Operator Type | Operator Symbols |
|---|---|
| Comparison | < > = <= >= |
| Addition/Subtraction | + - |
| Multiplication/Division | * / |
| Power | ^ |
| Grouping | ( ) , . |
The operators follow the usual precedence rules, so "1 + 2 * 3" equals 7. Expressions may be grouped using parentheses, so "(1 + 2) * 3" equals 9.
Functions
Expressions may include calls to the following functions:
Logical Functions
| Name | Description | Syntax |
|---|---|---|
| AND | Returns TRUE if all of its arguments are TRUE | =AND(logical1[, logical2,…]) |
| FALSE | Returns the logical value FALSE | =FALSE |
| IF | Specifies a logical test to perform | =IF(logical_test, value_if_true, value_if_false) |
| NOT | Reverses the logic of its argument | =NOT(logical) |
| OR | Returns TRUE if any argument is TRUE | =OR(logical1[, logical2,…]) |
| TRUE | Returns the logical value TRUE | =TRUE |
Mathematical Functions
| Name | Description | Syntax |
|---|---|---|
| ABS | Returns the absolute value of a number | =ABS(number) |
| ACOS | Returns the arccosine of a number | =ACOS(number) |
| ASIN | Returns the arcsine of a number | =ASIN(number) |
| ATAN | Returns the arctangent of a number | =ATAN(number) |
| ATAN2 | Returns the arctangent from x- and y-coordinates | =ATAN2(x_num, y_num) |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance | =CEILING(number) |
| COS | Returns the cosine of a number | =COS(number) |
| COSH | Returns the hyperbolic cosine of a number | =COSH(number) |
| EXP | Returns e raised to the power of a given number | =EXP(number) |
| FLOOR | Rounds a number down, toward zero | =FLOOR(number) |
| INT | Rounds a number down to the nearest integer | =INT(number) |
| LN | Returns the natural logarithm of a number | =LN(number) |
| LOG | Returns the logarithm of a number to a specified base | =LOG(number[, base]) |
| LOG10 | Returns the base-10 logarithm of a number | =LOG10(number) |
| PI | Returns the value of the PI constant | =PI() |
| POWER | Returns the result of a number raised to a power | =POWER(number, power) |
| RAND | Returns a random number between 0 and 1 | =RAND() |
| RANDBETWEEN | Returns a random number between the numbers you specify | =RANDBETWEEN(bottom, top) |
| SIGN | Returns the sign of a number | =SIGN(number) |
| SIN | Returns the sine of the given angle | =SIN(number) |
| SINH | Returns the hyperbolic sine of a number | =SINH(number) |
| SQRT | Returns a positive square root | =SQRT(number) |
| SUM | Adds its arguments | =SUM(number1[, number2, …]) |
| TAN | Returns the tangent of a number | =TAN(number) |
| TANH | Returns the hyperbolic tangent of a number | =TANH(number) |
| TRUNC | Truncates a number to an integer | =TRUNC(number)"; |
Statistical Functions
| Name | Description | Syntax |
|---|---|---|
| AVERAGE | Returns the average of its arguments | |
| AVERAGEA | Returns the average of its arguments, including numbers, text, and logical values | =AVERAGE(number1 [, number2, …]) |
| COUNT | Counts how many numbers are in the list of arguments | =AVERAGEA(number1 [, number2, …]) |
| COUNTA | Counts how many values are in the list of arguments | =COUNT(number1 [, number2, …]) |
| COUNTBLANK | Counts the number of blank cells within a range | =COUNTA(number1 [, number2, …]) |
| COUNTIF | Counts the number of cells within a range that meet the given criteria | =COUNTIF(range, criteria) |
| MAX | Returns the maximum value in a list of arguments | =MAX(number1 [, number2, …]) |
| MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values | =MAXA(number1 [, number2, …]) |
| MIN | Returns the minimum value in a list of arguments | =MIN(number1 [, number2, …]) |
| MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values | =MINA(number1 [, number2, …]) |
| STDEV | Estimates standard deviation based on a sample | =STDEV(number1 [, number2, …]) |
| STDEVA | Estimates standard deviation based on a sample, including numbers, text, and logical values | =STDEVA(number1 [, number2, …]) |
| STDEVP | Calculates standard deviation based on the entire population | =STDEVP(number1 [, number2, …]) |
| STDEVPA | Calculates standard deviation based on the entire population, including numbers, text, and logical values | =STDEVPA(number1 [, number2, …]) |
| VAR | Estimates variance based on a sample | =VAR(number1 [, number2, …]) |
| VARA | Estimates variance based on a sample, including numbers, text, and logical values | =VARA(number1 [, number2, …]) |
| VARP | Calculates variance based on the entire population | =VARP(number1 [, number2, …]) |
| VARPA | Calculates variance based on the entire population, including numbers, text, and logical values | =VARPA(number1 [, number2, …]) |
Text Functions
| Name | Description | Syntax |
|---|---|---|
| CODE | Returns a numeric code for the first character in a text string | =CODE(text) |
| CONCATENATE | Joins several text items into one text item | =CONCATENATE(text1 [, text2, …]) |
| FIND | Finds one text value within another (case-sensitive) | =FIND(find_text, within_text [, start_num]) |
| LEFT | Returns the leftmost characters from a text value | =LEFT(text[, num_chars]) |
| LEN | Returns the number of characters in a text string | =LEN(text) |
| LOWER | Converts text to lowercase | =LOWER(text) |
| MID | Returns a specific number of characters from a text string starting at the position you specify | =MID(text, start_num, num_chars) |
| PROPER | Capitalizes the first letter in each word of a text value | =PROPER(text) |
| REPLACE | Replaces characters within text | =REPLACE(old_text, stat_num, num_chars, new_text) |
| REPT | Repeats text a given number of times | =REPT(trext, number_times) |
| RIGHT | Returns the rightmost characters from a text value | =RIGHT(text[, num_chars]) |
| SEARCH | Finds one text value within another (not case-sensitive) | =SEARCH(find_text, within_text[, start_num]) |
| SUBSTITUTE | Substitutes new text for old text in a text string | =SUBSTITUTE(text, old_text, new_text[, instance_num]) |
| T | Converts its arguments to text | =T(value) |
| TEXT | Formats a number and converts it to text | =TEXT(value, format_text) |
| TRIM | Removes spaces from text | =TRIM(text) |
| UPPER | Converts text to uppercase | =UPPER(text) |
| VALUE | Converts a text argument to a number | =VALUE(text) |