Thanks

Chris Tellers

I know the 'round' function works in an equation but I need
to round up everytime. Is there syntax for this?

Thanks

Chris Tellers

Thanks

Chris Tellers

Hi Folks,

This is how I have been achieving rounding

**DOWN**to the nearest increment using INT, and I use ROUND to round**UP**.**=( int((int("target value to round"))/10))*10**In this case it is rounding

**DOWN**to nearest "10". To round down to nearest "5" just change the 10 in two places to 5 eg.**=( int((int("target value to round"))/5))*5**To round

**UP**to nearest increment substitute "INT" with "ROUND"**=( round((round("target value to round"))/10))*10**Enjoy!!

Eq1: "a" = 4.1

Eq2: "x" = int("a") '=4

Eq3: "y" = iif("a" - "x" > 0, "x" + 1, "a") '=5

"x" will always be the number "a" without any fractional component (4). "y" will always be "a" rounded up to the next whole number (5). If "a" is a whole number, a=x=y.