Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MROUND Function
- Thread starter ocan
- Start date
For positive numbers you could use:
n - (n Mod m)
e.g. x - (x Mod 3) would be equivalent to MRound(x, 3) where x is a positive number.
![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
n - (n Mod m)
e.g. x - (x Mod 3) would be equivalent to MRound(x, 3) where x is a positive number.
And to allow for negative number too, try this:
n - (n Mod (Sgn
*m))
e.g. x - (x Mod (Sgn(x)*3)) would be equivalent to MRound(x, 3) for any number.
n - (n Mod (Sgn
*m))e.g. x - (x Mod (Sgn(x)*3)) would be equivalent to MRound(x, 3) for any number.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question