jQuery grid supports the following commonly used Excel formulas.

In formulas, references to cells or range of cells are supported in this format.
  1. Absolute cell references e.g., $A$2, A$2, $A2, $A$1:$D$5, $A:$C, $5:$10 etc.
  2. Relative cell references e.g., A2, A1:D5, A:A, 6:8, etc.
If you found any commonly used formulas absent from the list, please let's know to consider them for addition in future versions.