Roundup Function

t_brown · 4 Dec 2013, 19:56

I am creating a dc railing that requires me to divide the LenX of the component by 9. obviously this can result in many different numbers, but I want it to round to the next highest whole number. I would normally just the RoundUp() function, but this isn't available. Anyone know any work arounds? I have been racking my brain and can't come up with anything. Thanks,

t_brown · 4 Dec 2013, 20:07

Just as I posted I figured out the Ceiling() function. I think this should work

goga63 · 5 Dec 2013, 21:19

=ROUND(LenX/9,0)