public static function PHPExcel_Calculation_Logical::STATEMENT_IF in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php \PHPExcel_Calculation_Logical::STATEMENT_IF()

* STATEMENT_IF * * Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. * * Excel Function: * =IF(condition[,returnIfTrue[,returnIfFalse]]) * * Condition is any value or expression that can be evaluated to TRUE or FALSE. * For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, * the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. * This argument can use any comparison calculation operator. * ReturnIfTrue is the value that is returned if condition evaluates to TRUE. * For example, if this argument is the text string "Within budget" and the condition argument evaluates to TRUE, * then the IF function returns the text "Within budget" * If condition is TRUE and ReturnIfTrue is blank, this argument returns 0 (zero). To display the word TRUE, use * the logical value TRUE for this argument. * ReturnIfTrue can be another formula. * ReturnIfFalse is the value that is returned if condition evaluates to FALSE. * For example, if this argument is the text string "Over budget" and the condition argument evaluates to FALSE, * then the IF function returns the text "Over budget". * If condition is FALSE and ReturnIfFalse is omitted, then the logical value FALSE is returned. * If condition is FALSE and ReturnIfFalse is blank, then the value 0 (zero) is returned. * ReturnIfFalse can be another formula. * * @access public * @category Logical Functions *

Parameters

mixed $condition Condition to evaluate: * @param mixed $returnIfTrue Value to return when condition is true * @param mixed $returnIfFalse Optional value to return when condition is false * @return mixed The value of returnIfTrue or returnIfFalse determined by condition

1 call to PHPExcel_Calculation_Logical::STATEMENT_IF()

PHPExcel_Calculation_Logical::IFERROR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php

* IFERROR * * Excel Function: * =IFERROR(testValue,errorpart) * * @access public * @category Logical Functions *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Logical.php, line 260

Class

PHPExcel_Calculation_Logical

PHPExcel_Calculation_Logical

Code

public static function STATEMENT_IF($condition = TRUE, $returnIfTrue = 0, $returnIfFalse = FALSE) {
  $condition = is_null($condition) ? TRUE : (bool) PHPExcel_Calculation_Functions::flattenSingleValue($condition);
  $returnIfTrue = is_null($returnIfTrue) ? 0 : PHPExcel_Calculation_Functions::flattenSingleValue($returnIfTrue);
  $returnIfFalse = is_null($returnIfFalse) ? FALSE : PHPExcel_Calculation_Functions::flattenSingleValue($returnIfFalse);
  return $condition ? $returnIfTrue : $returnIfFalse;
}