This content has been marked as final.
Show 5 replies

Equations  'Round' Function
Mahir Abrahim Feb 7, 2008 4:07 PM (in response to Chris Tellers)I did a quick search and didn't find any VBA equivalents for Excel's FLOOR and CEILING functions. However, you can use some other simple functions to create the same effect. See the example equations below.
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.
Equations  'Round' Function
Glenn Wilkins Feb 8, 2008 10:35 AM (in response to Mahir Abrahim)There is a ROUNDUP function in EXCEL but it looks like it doesn't work in equations. If should work if you use a design table.


Equations  'Round' Function
brian main Nov 27, 2008 3:57 PM (in response to Chris Tellers)add a equation ex. value=round(7/3) evaluates to 2
or value=round(7/3,2) evaluates to 2.33
Re: Equations  'Round' Function
Raymund Fababaer Sep 2, 2010 9:39 PM (in response to brian main)What if I want to round off to the nearest 10.
Let say 168.3 and the output should be 170?
What will be the formula?

Re: Equations  'Round' Function
Josh Brady Sep 2, 2010 9:54 PM (in response to Raymund Fababaer)Hint Study Mahir's post and understand it. The answer should come to you.
Edit  I missed that it was nearest 10, not FLOOR.
10*round(x/10) where 'x' is your number.

