5 Replies Latest reply on Jan 20, 2010 2:57 PM by philmodjunk

# help with if or round

### Title

help with if or round

### Post

Hi everyone, i need some help with a funtion, i have a calculation width x length and some time the result number ends with decimal, how can i round the result number if have decimal always round to the next entire number, for example:

10.1 = 11

5.3 = 6

4.2 = 5

x.x = X

thanks!

• ###### 1. Re: help with if or round

Int (Unrounded Value) + ( Int(Unrounded Value) = UnRounded Value )

The expression in parenthesis will return 1 if there's a decimal portion and 0 if it's a whole number.

• ###### 2. Re: help with if or round

hi Phil:

Thanks, but the result always should be round to up no to dowm number, i mean

if the result is 5.4 always be 6 not 5

• ###### 3. Re: help with if or round

Try:

Ceiling ( W * L )

• ###### 4. Re: help with if or round
Thanks!
• ###### 5. Re: help with if or round

Pichi wrote:

hi Phil:

Thanks, but the result always should be round to up no to dowm number, i mean

if the result is 5.4 always be 6 not 5

Sorry about that, Ceiling is definitely the better option.

My original expression should have been:

Int (Unrounded Value) + ( Int(Unrounded Value) UnRounded Value )