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
有那位知道怎麼做? |
發表於 2011-6-23 05:06 PM
| 