Function DEC2OCT has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.

Open

exports.DEC2OCT = function(number, places) {
  number = utils.parseNumber(number);
  if (number instanceof Error) {
    return number;
  }

• Read up
  Read up

Function VLOOKUP has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.

Open

exports.VLOOKUP = function (needle, table, index, rangeLookup) {
  if (!needle || !table || !index) {
    return error.na;
  }

• Read up
  Read up

Function BIN2HEX has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.

Open

exports.BIN2HEX = function(number, places) {
  // Return error if number is not binary or contains more than 10 characters (10 digits)
  if (!isValidBinaryNumber(number)) {
    return error.num;
  }

• Read up
  Read up

Function HLOOKUP has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.

Open

exports.HLOOKUP = function (needle, table, index, rangeLookup) {
  if (!needle || !table || !index) {
    return error.na;
  }

• Read up
  Read up

Function RATE has a Cognitive Complexity of 11 (exceeds 5 allowed). Consider refactoring.

Open

exports.RATE = function(periods, payment, present, future, type, guess) {
  // Credits: rabugento

  guess = (guess === undefined) ? 0.01 : guess;
  future = (future === undefined) ? 0 : future;

• Read up
  Read up

Function EXC has 28 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.PERCENTRANK.EXC = function(array, x, significance) {
  significance = (significance === undefined) ? 3 : significance;
  array = utils.parseNumberArray(utils.flatten(array));
  x = utils.parseNumber(x);
  significance = utils.parseNumber(significance);

Function INC has 28 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.PERCENTRANK.INC = function(array, x, significance) {
  significance = (significance === undefined) ? 3 : significance;
  array = utils.parseNumberArray(utils.flatten(array));
  x = utils.parseNumber(x);
  significance = utils.parseNumber(significance);

Function PROB has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

exports.PROB = function(range, probability, lower, upper) {
  if (lower === undefined) {
    return 0;
  }
  upper = (upper === undefined) ? lower : upper;

• Read up
  Read up

Function BIN2OCT has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

exports.BIN2OCT = function(number, places) {
  // Return error if number is not binary or contains more than 10 characters (10 digits)
  if (!isValidBinaryNumber(number)) {
    return error.num;
  }

• Read up
  Read up

Function IMARGUMENT has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

exports.IMARGUMENT = function(inumber) {
  // Lookup real and imaginary coefficients using exports.js [http://formulajs.org]
  var x = exports.IMREAL(inumber);
  var y = exports.IMAGINARY(inumber);

• Read up
  Read up

Function OCT2HEX has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

exports.OCT2HEX = function(number, places) {
  // Return error if number is not octal or contains more than ten characters (10 digits)
  if (!/^[0-7]{1,10}$/.test(number)) {
    return error.num;
  }

• Read up
  Read up

Function parseDate has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

exports.parseDate = function(date) {
  if (!isNaN(date)) {
    if (date instanceof Date) {
      return new Date(date);
    }

• Read up
  Read up

Function AVERAGEIF has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.AVERAGEIF = function(range, criteria, average_range) {
  if (arguments.length <= 1) {
    return error.na;
  }
  average_range = average_range || range;

Function IMARGUMENT has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.IMARGUMENT = function(inumber) {
  // Lookup real and imaginary coefficients using exports.js [http://formulajs.org]
  var x = exports.IMREAL(inumber);
  var y = exports.IMAGINARY(inumber);

Function FREQUENCY has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.FREQUENCY = function(data, bins) {
  data = utils.parseNumberArray(utils.flatten(data));
  bins = utils.parseNumberArray(utils.flatten(bins));
  if (utils.anyIsError(data, bins)) {
    return error.value;

Function IPMT has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Open

exports.IPMT = function(rate, period, periods, present, future, type) {
  // Credits: algorithm inspired by Apache OpenOffice

  future = future || 0;
  type = type || 0;

Function flattenShallow has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

exports.flattenShallow = function(array) {
  if (!array || !array.reduce) {
    return array;
  }

• Read up
  Read up

Function SUMIF has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

exports.SUMIF = function(range, criteria) {
  range = utils.parseNumberArray(utils.flatten(range));

  if (range instanceof Error) {
    return range;

• Read up
  Read up

Function CEILING has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

exports.CEILING = function(number, significance, mode) {
  significance = (significance === undefined) ? 1 : Math.abs(significance);
  mode = mode || 0;

  number = utils.parseNumber(number);

• Read up
  Read up

Function INTERVAL has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

exports.INTERVAL = function (second) {
  if (typeof second !== 'number' && typeof second !== 'string') {
    return error.value;
  } else {
    second = parseInt(second, 10);

• Read up
  Read up