FIELD value round UP

[Irreb]

Hello Everyone,

i need some help understanding how to round UP a value in a field.

i have a field inside a block that divides a line length by a certain value. Though i can round up to the closed whole number i would need to round it to the closed higher number.

The case reported above shows that dividing 3350 by 1066.8 gives a result of about 3.14 and the FIELD will show 3, i need this to show 4.

[jtohill]

You could just add 1 to the formula and it would work on all numbers except when it is a whole number. 

[jtohill · Accepted solution]

Sorry, add .499 so it works with all numbers.

[Irreb]

wow, how did i not think of it.....thanks

[ldreauxrodgers]

That is what I ended up doing, but just didn't know if there was a setting that would do it for me.