Formula Syntax

SheetRocks uses the same basic formula syntax as other common spreadsheets (Excel, Google Sheets, etc). So if you know how to use other spreadsheets, SheetRocks should be very intuitive. Specifically, SheetRocks syntax includes:
‍
- Over 400 formulas, which all have syntax like FORMULA_NAME(argument1, argument2, ...)
- Formulas always start with the equals sign, "="
- Arithmetic operators (plus, minus, division (/), multiplication (*), parenthesis)
- Boolean operators (=, >, <, <=, >=- String literals like "this is text"
- String concatenation via the ampersand &
- Numbers like 10, 12.0, 55%, $100, 1e5
- Dates like "11/3/1983" or "12/22/1992"
- References to other cell ranges like A1, A2:B3, C:D, A2:D, 3:4
- Cross-sheet references like Sheet1!A3 or "Sheet name with space"!A:D
- One dimensional arrays like [1,2,3]
- Two dimensional arrays like {1,3;4,5}