Rounding Formula

  • Thread starter Thread starter mpd
  • Start date Start date
M

mpd

Guest
How can I construct a formula (perhaps an IIF...not really sure) so that only a value which has three decimal places (and the third decimal is a half)is rounded up?

For example, I want 2.625 rounded up to 2.63 but 2.620 to remain at 2.62.

I have converted the data type to currency which does round up but the underlying value remains 2.625 which throws my totals.
 
Function Round2DP(X)
Round2DP = Int(X * 100 + 0.5) / 100
End Function
 

Users who are viewing this thread

Back
Top Bottom