How do I use NumXL functions in my Excel sheet?

NumXL allows you to directly use its functions within your Excel sheet in the same way you would with built-in Excel functions.

In order to illustrate the use of a NumXL function within an Excel sheet, consider the following example:

  • Open MS Excel and create a series of 20 numbers.
  • Using the Excel toolbar, Click the "Insert function" field (labeled "fx").
  • An "Insert Function" Dialog pops up.

  • Using the dialog fields, fill in the function input by selecting cells from your worksheet.
  • For more information about this particular function, click on the "Help on this function" hyperlink to bring up the help file.
  • Once you are done, click OK.
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Support Team

    Num XL doesn't not show up as in the first diagram for me. So what should I do?

  • 0
    Avatar
    Support Team

    The NumXL functions are only visible if you install and activated NumXL add-in. Please, check "About NumXL" menu under "Info" (right-most icon) in NumXL toolbar.

    In rare occasions, the NumXL add-in was disabled in the Excel add-ins manager, so check the Excel add-ins manager and make sure the NumXL entry is enabled (aka. checked).

    To locate Excel add-ins manager, please see the following article:

    https://support.numxl.com/hc/en-us/articles/208223553-Where-do-I-find-Excel-Add-ins-Manager-