cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Round to nearest 0.5

Hi,

 

I'm wondering if there is a way to use a formula to round numbers to the nearest 0.5 .

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Round to nearest 0.5

You can use this for a column formula:

 

Round( :Data * 2 ) / 2

Or you could make your own function in a script:

 

nearest half = Function( { x }, Round( x * 2 ) / 2 );

View solution in original post

2 REPLIES 2

Re: Round to nearest 0.5

You can use this for a column formula:

 

Round( :Data * 2 ) / 2

Or you could make your own function in a script:

 

nearest half = Function( { x }, Round( x * 2 ) / 2 );
gzmorgan0
Super User (Alumni)

Re: Round to nearest 0.5

x = [122.34, 10.2, 33.6, 45.75];

show( round( x/0.5,0 )*0.5 );

/*:
Round(x / 0.5, 0) * 0.5 = [122.5, 10, 33.5, 46];

 oops, Mark beat me to it.