\PhpOffice\PhpSpreadsheet\Calculation\MathTrigCeiling

Summary

Methods
Properties
Constants
funcCeiling()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
argumentsOk()
floorCheck1Arg()
No private properties found
N/A

Methods

funcCeiling()

funcCeiling(float  $number, float  $significance = null) : float|string

CEILING.

Returns number rounded up, away from zero, to the nearest multiple of significance. For example, if you want to avoid using pennies in your prices and your product is priced at $4.42, use the formula =CEILING(4.42,0.05) to round prices up to the nearest nickel.

Excel Function: CEILING(number[,significance])

Parameters

float $number

the number you want the ceiling

float $significance

the multiple to which you want to round

Returns

float|string —

Rounded Number, or a string containing an error

argumentsOk()

argumentsOk(float  $number, float  $significance) : float|string

Avoid Scrutinizer problems concerning complexity.

Parameters

float $number
float $significance

Returns

float|string —

floorCheck1Arg()

floorCheck1Arg() : void