Thanks a lot David! works great. My main issues was that I was getting the syntax wrong.
On Oct 14, 4:04 am, David Rutten <[EMAIL PROTECTED]> wrote: > Stan, > > rounding rounds to a number of decimals, not to a certain numeric > interval. > To use Round, do the following: > > Round(x, 4) > > which will round a number to 4 decimal digits. Hence, if x equals pi, > then the result will be: 3.1416 > > In order to 'round' a number to the nearest value in a multiplication > table, you have to use Patricks approach: > > r * CInt(x/r) > > where x is the value that needs 'rounding' and r is the table base > (0.2 in your case). CInt is a function which converts a floating point > number to its nearest integer. > > -- > David Rutten > Robert McNeel & Associates > > On Oct 14, 12:55 am, Stan <[EMAIL PROTECTED]> wrote: > > > > > Hi > > > Thanks for the reply, > > > I think this will work great however I cant seem to be able to get the > > expression to round correctly. Im not sure what I have to replace "d" > > with. ( > > > Round(x(, d)) i tried many things and I dont get it to give me any > > results. also could it be not working b/c it says its receiving > > doubles and not floats? > > > thanks > > > Stan > > > On Oct 12, 10:18 am, Patrick <[EMAIL PROTECTED]> wrote: > > > > Hi Stan, > > > > how about this > > > > xr= increment(Round(x/increment)) > > > > where x is the the number you want to round > > > and xr is the rounded value > > > > Patrick > > > > On Oct 12, 3:24 am, Stan <[EMAIL PROTECTED]> wrote: > > > > > Does anyone have any idea how to round a set of numbers to increments > > > > of say .2 for example. > > > > > Also whats the proper format for writing the Rounding expressions. I > > > > cant seem to be able to have the correct syntax. > > > > > Round(x[not sure]) > > > > > Thanks > > > > > Stan- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > - Show quoted text -
