View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.