Table formula not rounding up

[tevansHMH]

I have added formulas to table cells that I want to always round up if more than a whole number. I have tried round() and trunc() and neither will round up. My formula looks like this

=trunc(((D3/150)*144)/2)/56 this returns 22.285714 not 23

=trunc(((D3/150)*144)/2)/144 this returns 8.666667 not 9

D3 enters a value in Cell D3

Data Type is set to Decimal Number and Formatting is set to (none)

All I can find in my research is to use either round() OR trunc() and neither work in my case.

Thank you in advance for your help.

[dbroad]

Match your parentheses  The formulas must be in the form: =function (argument)

Example: =round(D3/150*144/2/56)

If this is about venting or occupant load though, you may always need to round up.

[tevansHMH]

yes, this is for attic ventilation so must always round up.

[dbroad]

Note: The round function doesn't always round up.

[tevansHMH]

Is there a function that will force it to round up?

[dbroad · Accepted solution]

Excel has a roundup function. With AutoCAD, round(#+0.5) will do.