round up to the next whole number

i'm working in a worksheet, and I want to round the number up to the next whole number. I've tried =Round(criteria), but if the true answer is less that 0.5, the number is rounded down, i want it rounded up, always.

By Jonathan Pickup, July 2, 2009
8 replies

I was just wondering about Vw Worksheet functions and found this old thread requesting 'Floor' & 'Ceiling' (round up & down) functions. Have the worksheet rounding functions been expanded / improved in Vw2015? Thanks.