Search results

CEILING(216,5) = 220 explanation : same with 216/5 =43.2, if you use 216 Div 5 then result will be 43. so after div you add by 1. with mean you get result 44. then 44 * 5 = will get result 220,

use SQL like this SELECT PRICE, ((PRICE\500)+1)*500 as CEILING FROM STOCK WHERE CODE= "S00001252" similar result with excel function CEILING(number,significance) -- > Ceiling(Price,500).