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)