You are here

public static function PHPExcel_Calculation_Engineering::GESTEP in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php \PHPExcel_Calculation_Engineering::GESTEP()

* GESTEP * * Excel Function: * GESTEP(number[,step]) * * Returns 1 if number >= step; returns 0 (zero) otherwise * Use this function to filter a set of values. For example, by summing several GESTEP * functions you calculate the count of values that exceed a threshold. * *

Parameters

float $number The value to test against step.: * @param float $step The threshold value. * If you omit a value for step, GESTEP uses zero. * @return int

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Engineering.php, line 2215

Class

PHPExcel_Calculation_Engineering
PHPExcel_Calculation_Engineering

Code

public static function GESTEP($number, $step = 0) {
  $number = PHPExcel_Calculation_Functions::flattenSingleValue($number);
  $step = PHPExcel_Calculation_Functions::flattenSingleValue($step);
  return (int) ($number >= $step);
}