返回列表 回復 發帖

About Excel

 ,  描述: Rounding Problem
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

有那位知道怎麼做?
沒有人知道怎麼寫command嗎???
返回列表