Gustav Brock
gustav at cactus.dk
Fri Jul 11 05:55:33 CDT 2014
Hi all
Did you know, that it is quite easy to build a Fix that doesn't round numeric down (towards zero) but numeric up (away from zero):
Public Function FixUp(ByVal dblValue As Double) As Long
FixUp = -Sgn(dblValue) * Int(-Abs(dblValue))
End Function
So:
FixUp(1.46) => 2
FixUp(-1.46) => -2
while:
Fix(1.46) => 1
Fix(-1.46) => -1
/gustav