Static Public Member Functions
static	ceiling ($number, $significance=null)

static	math ($number, $significance=null, $mode=0)
	CEILING.MATH.

static	precise ($number, $significance=1)
	CEILING.PRECISE.

Member Function Documentation

◆ math()

static PhpOffice\PhpSpreadsheet\Calculation\MathTrig\Ceiling::math	(	$number,
		$significance = null,
		$mode = 0 )

static

CEILING.MATH.

Round a number down to the nearest integer or to the nearest multiple of significance.

Excel Function: CEILING.MATH(number[,significance[,mode]])

Parameters

mixed	$number	Number to round Or can be an array of values
mixed	$significance	Significance Or can be an array of values
array \| int	$mode	direction to round negative numbers Or can be an array of values

Return values

array|float|string Rounded Number, or a string containing an error If an array of numbers is passed as an argument, then the returned result will also be an array with the same dimensions

◆ precise()

static PhpOffice\PhpSpreadsheet\Calculation\MathTrig\Ceiling::precise	(		$number,
			$significance = 1 )

static

CEILING.PRECISE.

Rounds number up, away from zero, to the nearest multiple of significance.

Excel Function: CEILING.PRECISE(number[,significance])