Inserting Functions

image_pdfimage_print

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. Select Jedox from the category drop-down list (see screenshot below). This category includes all PALO functions available in Jedox Web. 

Almost all Jedox Spreadsheet functions are programmed in the same way as the corresponding Excel counterparts. There are two exceptions:

  • The Jedox Web HYPERLINK() function has more functionality than its Excel counterpart. For more information on this function, see HYPERLINK Function.
  • The Jedox INFO() function returns different information than its Excel counterpart. For more information on this function, see INFO Function.
image_pdfimage_print