Board logo

標題: About Excel [打印本頁]

作者: ssad47    時間: 2011-6-23 05:06 PM     標題: About Excel

I have a rounding problem for EXcel.

I need to:

Round down to 0 for decimals 0.01, 0.02
Round up to 0.05 for decimal 0.03, 0.04
Round down to 0.05 for decimal 0.06,0.07
Round up to 0 for decimal 0.08, 0.09

Eg.
41.47 ==> 41.45
      46.53  ==> 46.55
      49.89 ==> 49.90

有那位知道怎麼做?
作者: ssad47    時間: 2011-7-4 12:06 PM

沒有人知道怎麼寫command嗎???




歡迎光臨 公仔箱論壇 (http://5.39.217.76/) Powered by Discuz! 7.0.0