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
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!!!