Support Center

We add new functions from time to time. Please see the list of functions for the latest information.

Some functions can be used for free. Functions that cannot be used for free are called premium functions. These are marked with a  icon in the list of functions. You can try a premium function for 7 days for free.

Some functions can be used offline. Functions that cannot be used offline are called server-side functions. These are marked with a  icon in the list of functions. You can make 1,000 server-side function calls per month for free.

For Excel on Windows or Mac, you need a version of Office connected to a Microsoft 365 subscription and released after August 2020. Please see the system requirements for more details.

1. Click Insert.
2. Click Get Add-ins.
3. Search for QRS Toolbox.
4. Click Add next to the correct search result.
5. Click Continue after reading the terms and privacy policy.

1. Click Home.
2. Click Show Task Pane.

1. Click Home.
2. Click Show Task Pane.
3. Click Custom functions.
4. Click the name of the function.
5. Click Start my 7-day free trial.

1. Click Home.
2. Click Show Task Pane.
3. Click Server call quotas.

The same way you use a native function like SUM or AVERAGE. For example, to calculate value-at-risk at the 95% confidence level for the standard normal distribution, enter the formula =QRS.VAR.NORMAL(0.95) into a cell.

To read the documentation of a function:

1. Click Home.
2. Click Show Task Pane.
3. Click Custom functions.
4. Click the name of the function.

This can happen for many reasons. Perhaps you don't have the right to use a premium function. Or perhaps you have fully utilized your quota of server-side function calls. Please hover your cursor over the error button to see the reason.

This can happen for many reasons. Perhaps you mistyped the function name. Or perhaps we introduced the function recently and Excel is reading outdated files from the Office cache. If that is the case, you can force Excel to fetch the new files by adding QRS Toolbox to Excel again or clearing the Office cache manually.

This can happen for many reasons. Perhaps you left out a required parameter. Or perhaps you passed an invalid argument type or value. Please hover your cursor over the error button to see the reason.

This can happen for many reasons when the results of a function span multiple cells. Perhaps some of the cells are not blank. Or perhaps some of the cells are merged. Please hover your cursor over the error button to see the reason.

1. Click Home.
2. Click Show Task Pane.
3. Click Custom functions.
4. Click the name of the function.
5. Click Add to shopping cart.
6. Click View shopping cart.
7. Click Pay now after confirming your order details. The checkout page will open in your default browser. Pay for your order. Return to Excel.
8. Click Check my order status.

1. Click Home.
2. Click Show Task Pane.
3. Click Server call quotas.
4. Enter the number of calls.
5. Click Add to shopping cart.
6. Click View shopping cart.
7. Click Pay now after confirming your order details. The checkout page will open in your default browser. Pay for your order. Return to Excel.
8. Click Check my order status.

If your billing address is in a country whose local currency is supported by our online reseller, you will be charged in the local currency. Otherwise, you will be charged in United States Dollar.

You can pay using any payment method supported by our online reseller, which includes credit card, PayPal, and Apple Pay.