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..
evendAsked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.