Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Crystal Rounding

I have a Number field (Revenue) which is dollar value.  I want to round to the nearest Nickle.

2.39  = 2.40    
2.36 = 2.35    
2.37 = 2.35

etc..
0
evend
Asked:
evend
1 Solution
 
mlmccCommented:
Check Ken Hamaday's formula

http://www.kenhamady.com/form22.shtml

mlmcc
0
 
evendAuthor Commented:
Awesome thank!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now