CelesteCS Math plugin's main macro is Numerical Expression, which allows one to enter a formula on the Confluence page. The formula evaluation is performed on page load on the server side. Formula may be the only part of the macro body, or specified as a part of text, enclosed in curly or square brackets - controlled by the parameter.
The power of Numerical Expression is in the ability to use outside data – table cell values and macros – as formula operands. Table cells are referenced in a simple Excel-like manner, for example 'ROUND(Table1.A2)'. Table cell ranges are also supported and may be specified like in the following example: SUM(Table1.A2:B10). Source table may be located on current or other wiki page.
Macro may be specified as one of the formula operands. Most of the macros are rendered as a text, so if you want to use numerical part of macro output, use VALUE function, which returns the first numerical value of its parameter.
If formula text is formatted, this format will be applied to the Numerical Expression output. If you want to apply some text format to the macro output, for example show the result as a currency, use FORMAT function.
Find out more here: