Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted

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
Highlighted

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 );
Learn it once, use it forever!

View solution in original post

2 REPLIES 2
Highlighted

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 );
Learn it once, use it forever!

View solution in original post

Highlighted
gzmorgan0
Super User

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. 

Article Labels

    There are no labels assigned to this post.