Forum Discussion
Solved
Round to nearest $5
I'm trying to round to the nearest $5. HPayRoundUp = ROUNDUP([HPay],-0.5) It takes 22.45 and is rounding to 30. If I go any lower (-0.2) it goes to 23
Hi kattlees,
Then you can a formula like this :
HPayRoundUp = (INT([HPay]/5)+1)*5
and if you have negative number then you will adapt it...
Ninter
Not quite. I want 22.45 to go to 25.. 22.01 would go to 25
Everything would round UP to the next $5 increment.
16.45 would go to 20, 27.64 would go to 30.
Hi kattlees,
Then you can a formula like this :
HPayRoundUp = (INT([HPay]/5)+1)*5
and if you have negative number then you will adapt it...
Ninter
Thank you!!!