This function examines a number series for those values that fall within a specified variance of a selected value.

This form has four parameters

• the column for analysis - a datalist of numbers
  
• the value for comparison
  
• the permitted variance
  
• the type of variance in relation to the value for comparison - more than only, more or less, less than only
  

The audit trail header is given in the form of a maximum/minimum range e.g. Col 'X' Range 1100 to 900

Remarks

This function operates on numeric (decimal) values only.

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.

See also

List Analysis