Community
 
Aggiungi lista preferiti Aggiungi lista nera Invia ad un amico
------------------
Crea
Profilo
Blog
Video
Sito
Foto
Amici
   
 
 

XNUMBERS - Multi Precision Floating Point Calculus For EXCEL

Functions Handbook

 Version 2 include a new application for searching and pasting all Xnumbers functions, that are also catalogued by subject. This feature born to overcame the poor standard Excel 97/2000 function wizard (Excels XP is improved ) can also submit all Xnumbers macros. You can show the Handbook by click on the icon installed, (near the Window help ).

 

 

Category: you can filter macros by category (Arithmetic, Statistical, Trigonometric, etc.)

Macro Type: filter by macro functions, macro Subroutines, or both

Paste Into: choose the cell you wont to paste a function; default is the active cell

Search: finally, you can search macros by words or sub-words contains into their name or description as you like. For example, if you input "div" you get all macros that match words like (div, divisor, division,...)

You can associate multi words search in AND/OR. Separate words with comma "," for OR; with plus "+", for AND. For example, if you type "+div +multi" you will get all the rows containing words like (div, divisor, division,...) and words like (multi, multiprecision,...). On the contrary, if you type "div, multi", you get all the rows that contain words like (div, divisor, division,...) or also the words like (multi, multiprecision,...).

Help: after selecting a row, a short description appears at the left-bottom area. For more information click on the Help button.

Paste: for pasting the function simply click "OK". This activate the standard Excel function wizard. If the macro selected is a Subroutine, the OK button simply runs the macro.

 

NB. Function Handbook is the only way to start a macro contained into Xnumber 2.2 add-in. Version 2.2 do not support the menu bar, available in old ver. 2.x. In order to minimize the pack size, and to add same new functions - sorry - we have to renounce it.