﻿ C1Binding Expression Syntax Elements | ComponentOne Binding Expressions for WPF and Silverlight
ComponentOne Binding Expressions for WPF and Silverlight
In This Topic
C1Binding Expression Syntax Elements
In This Topic

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)