Functions can be inserted into spreadsheets through the Formulas menu item in the toolbar. Click on the Insert function button, as indicated below:
It works in much the same way as in Excel. Jedox is preselected as the category, and all PALO functions are available in in the listbox.
Almost all Jedox Spreadsheet functions are programmed in the same way as the corresponding Excel counterparts. There are two exceptions: