Binding Expressions support a subset of the functions available in Microsoft Excel. Your C1Binding Expressions may include logical functions (IF, AND, OR), mathematical functions (ABS, FLOOR, LOG, SUM), statistical functions (AVERAGE, COUNT, MAX), and text functions (CONCATENATE, TRIM, UPPER). The complete list of supported functions can be found in the documentation.

Suppose you want to apply conditional formatting to your bound values. You can accomplish this using the IF function, which performs conditional logic. For example, the following XAML snippet formats values greater than 1,000 to appear bold:

<TextBlock
  Text="{c1:C1Binding Expression = 'Amount'}"
  FontWeight="{c1:C1Binding Expression='IF(Amount &gt; 1000, |bold|, |normal|)' }" />

Use quotes in your binding expressions without breaking your XAML. C1Binding expressions support inline quotes in two forms: & quot; or use of the pipe (|) character. For example, the XAML snippet above could be rewritten with the following for more readability:

<TextBlock
  Text="{c1:C1Binding Expression=
    'CONCATENATE(Amount, | Tax: |, Amount * 8.5%' }" />

C1Binding objects use the C1CalcEngine class to parse and evaluate expressions. It is a public class and can be used independently to parse strings into Expression objects or parse strings to evaluate resulting expressions. For example, you could have a calculated TextBox that allows users to type expressions (ie, 4 + 16), and have them evaluated when the control loses focus by using the C1CalcEngine’s Evaluate method.