## How to use Excel CEILING.PRECISE function

Introduction CEILING.PRECISE function in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to a defined multiple or the nearest integer. It is different from CEILING function in the sense that whatever may be the sign of the number, it always rounds up. By default it uses 1 as a multiple. For example, number 1.5 is rounded up to nearest multiple of 1 by formula =CEILING.PRECISE(1.5,1) which gives 2 as the result. Syntax…