Continuum evaluates phrase-style expressions before symbolic math, then resolves dependencies across the complete document. These examples describe production behavior.
Assignments and subtotals
Use name = expression to store a value. Spaces in an authored name normalize to underscores. A standalone subtotal totals the current section; a line such as operating_total = stores that subtotal.
Subtotal boundaries occur at headings, previous subtotals, and subtotal assignments. A simple percentage line inside a subtotal section adjusts the running subtotal multiplicatively.
revenue = 1000
costs = 300
10%
subtotal
Arithmetic and logic
- Arithmetic:
+,-,*,/,%,^,**,×,÷, andmod. - Comparisons:
==,!=,>,<,>=, and<=. - Logic:
and,or,&&,||,true, andfalse. - Numbers: thousands separators,
kshorthand, percent literals, parentheses, and unary signs.
Natural math
Production phrases include total of, sum of, average of, mean of, count of, and median of. Percentage phrases cover % of, % on, % off, percent-of-base, reverse percentage, and increase/decrease forms. Multiplier phrases answer “what x” questions.
Rounding supports plain, up, and down variants, optionally to the nearest numeric or named step. Conditionals support result if condition, result unless condition, and if … then … else ….
Rates and time
Mix natural phrases, rates, percentages, and time conversions.
- 17,680
- 26,912
- 390
- 418
Rates and time
Rates can be written as 100 per day, $500 / month, or 3 widgets a week. Apply a rate over a duration, multiply by a duration, solve an inverse with at, combine compatible rates, or convert between second, minute, hour, day, week, month, and year units.
Compound durations work too: 1 hour and 30 minutes in min.
Finance and currency
Growth phrases model a principal over time at a rate with optional monthly, quarterly, or yearly compounding. Production expressions also cover interest, ROI multiples, annualized returns, required investment capital, present value, and loan repayment/interest totals.
Common currency symbols and aliases—including USD, EUR, GBP, JPY, CAD, AUD, CHF, CNY, and INR—are preserved in context-aware output. Results can render as numbers, percentages, fractions, multipliers, currencies, rates, quantities, or converted durations.
Currency inheritance
Declare a monetary amount once. Compatible calculations carry its currency through aliases, dependencies, resolvable forward references, and folder shared variables:
rate = 100 in EUR
hours = 8
total = rate * hours
half = total / 2
ratio = total / rate
Here total is €800.00, half is €400.00, and ratio is the plain number 8. An explicit annotation introduces a currency or agrees with an inherited one; total in USD is an error, not an exchange conversion.
- Addition and subtraction require matching currencies. A plain zero is allowed; a nonzero untyped amount must be annotated, for example
extra = 20 in EURbeforetotal + extra. - Multiplying or dividing money by a plain number retains its currency. Dividing matching currencies produces a plain ratio.
- Percentage adjustments preserve currency, including
total + 10%. - Mixed currencies and unsupported dimensions such as money multiplied by money are rejected. Negative monetary values are supported; division by zero remains an error.
- Subtotals and floating totals enforce compatible currencies. A document containing both a monetary amount and an unrelated nonzero plain number can therefore have valid individual results and an incompatible total.
The result rail, Quick Calculation, variable popups, and live canvas cards use the same currency information. No exchange rates are fetched or applied.
Errors
Unknown variables, division by zero, syntax errors, and unsupported expression nodes are shown at line and token range where possible. Continuum retries dependency resolution before reporting an unknown variable, so a later resolvable assignment can still satisfy an earlier reference.
Discover supported formulas
Use Ctrl+Space (or Alt+I on macOS) in the editor to search the shipped calculation catalog. Suggestions cover arithmetic, comparisons, logic, aggregates, percentages, multipliers, rounding, conditionals, rates, duration conversion, currency formatting, investment calculations, and enabled templates. Each formula explains its inputs and previews a result when complete.
Search by intent such as profit, margin, runway, discount, present value, or annual return. Contextual formulas insert existing syntax: they do not add Excel function calls or array values. Currency annotations and inheritance enforce compatible monetary calculations; they do not perform exchange-rate conversion. Literal-only inputs stay editable literals.
Discover a formula
Open this example in the editor, remove the margin expression, then press Ctrl+Space after its equals sign.
- 1—
- 212,000
- 38,500
- 43,500
- 529.17%
See contextual autocomplete for input matching, acceptance, and preview behavior.