rounding up or down
On Dec 21, 2:32*am, Eqa wrote:
Aparently 4 is not lucky. Hence 58.
What about the number 3? If that is not unlucky, perhaps you could
round to integers ending in 38 and 88. That is nice because the
numbers are evenly spaced. That lends itself to a simpler formula for
rounding, namely:
=mround(A1-38,5) + 38
MROUND is in the Analysis ToolPak, a Microsoft add-in. If you prefer
to use only standard functions, you could write:
=50*round((A1-38)/50,0) + 38
But of course, if the Chinese business community has standardized on
integers ending in 58 and 98, so be it.
|