Question: how ceiling function works in excel?
Answer: Excel CEILING Function. The Excel CEILING function rounds a given number up to the nearest specified multiple. CEILING works like the MROUND function, but CEILING always rounds up. A rounded number.