-63 is rounded up to -6. CEILING Function is very similar to the floor function in excel but the result is just opposite of the floor function where floor function gave us the result to the less significance ceiling formula gives us the result to the higher significance so for example if we have number as 10 and significance as 3 then 12 will be the result. How to use Floormath and Ceilingmath in Excel When would you use Floormath and when would you use Ceilingmath in Excel Visit our website httpswwweasy.
However if the mode argument is provided and is non-zero negative numbers are rounded away from zero see cell B5.
It will return a number that is rounded up to the nearest integer or multiple of significance. CEILINGMATH Function in Excel rounds a supplied number up regardless of the significances sign to the nearest multiple of a given number. However if the mode argument is provided and is non-zero negative numbers are rounded away from zero see cell B5. Positive numbers with decimal portions are rounded up to the nearest integer eg.