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