×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Help using the round function in clipper

Help using the round function in clipper

Help using the round function in clipper

(OP)
Is there a way to make the clipper round function always round up.  If I round 1.4285 I want it always to come out 2 not 1

RE: Help using the round function in clipper

You could add .5 to the number before rounding it

CODE

? Round(1.4285 + .5)

Regards

Griff
Keep Smileing

RE: Help using the round function in clipper

(OP)
Thanks, that works certainly with the example I gave you and I assume it would work with numbers that come out differently such as 1.75 which would also round to 2 even after adding the .5.  I am wondering if there is any figure that would not give the desired result.  I guess I need to do some testing.  

RE: Help using the round function in clipper

-1.6 might round badly?

Regards

Griff
Keep Smileing

RE: Help using the round function in clipper

(OP)
Everything rounds exactly as I wanted with one exception.  I tested every number from 1.100 to 1.9999 and they all rounded to 2 which is exactly what I wanted. The only number that does not round properly is 1.000. That rounds to 2 and of course I want it to stay at 1.  But I can deal with that some other way.

RE: Help using the round function in clipper

You might try adding .499999....  out to the last decimal you will be using.  I assume 1.000 plus .4999 will round to 1.00.   untested

Jim Rumbaugh

RE: Help using the round function in clipper

You can create a function pretty easily, use the INT() function, to create a second value subtract the two and if there is a difference add one to the INT() variable and you have rounded up one whenever there is a value to the
right of the decimal.

Jim C.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close