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 -
