Functions Overview

Click on the names of the functions below to go to their individual ‘in-depth’ help sections.

Function Name What it does
 =xln(Cellref,Integer) Displays a mathematical expression showing the values of the expression. The INTEGER is an optional flag to set the number of decimal places for each of the numerical components of the expression. If Integer is omitted, an adaptive number format is used
 =xlv(Cellref,Integer,Integer) Displays a mathematical expression showing the variable names of the expression. For the xlv function, all variable names must be on the same row as the value it is representing. The first INTEGER is an optional flag to set the number of decimal places for each of the numerical components (if any) of the expression.  If the first INTEGER is omitted, an adaptive number format is used. The second INTEGER is an optional flag to specify the exact column number where the variable names are located. If the second optional INTEGER is omitted, xlv searches to the left of the cellref and returns the first non numeric value. If no variable name is found in the first 10 cells to the left of the cellref, “XL_Viking_NoVar” is returned.
 =xlvu(Cellref,Integer,Integer) Displays a mathematical expression showing the variable names of the expression. For the xlvu function, all variable names must be in the same column as the value it is representing. The first INTEGER is an optional flag to set the number of decimal places for each of the numerical components (if any) of the expression. If the first INTEGER is omitted, an adaptive number format is used. The second INTEGER is an optional flag to specify the exact row number where the variable names are located. If the second optional INTEGER is omitted, xlvu searches in the cells above the cellref and returns the first non numeric value. If no variable name is found in the first 49 cells above the cellref, “XL_Viking_NoVar” is returned.