用 RoundTo、Format、FormatFloat、FormatCurr 格式化的效果

用 RoundTo、Format、FormatFloat、FormatCurr 格式化的效果

RoundTo--------------------------------

RoundTo(1.115,-2)=1.11

RoundTo(1.125,-2)=1.12

RoundTo(1.135,-2)=1.13

RoundTo(1.145,-2)=1.14

RoundTo(1.155,-2)=1.16

RoundTo(1.165,-2)=1.17

RoundTo(1.175,-2)=1.18

RoundTo(1.185,-2)=1.19

RoundTo(1.195,-2)=1.20

Format-------[参数为Currency类型]-------------------------

Format('%2.2n',1.115)=1.12

Format('%2.2n',1.125)=1.12

Format('%2.2n',1.135)=1.14

Format('%2.2n',1.145)=1.14

Format('%2.2n',1.155)=1.16

Format('%2.2n',1.165)=1.16

Format('%2.2n',1.175)=1.18

Format('%2.2n',1.185)=1.18

Format('%2.2n',1.195)=1.20

Format--------[参数为Extended，Float类型]------------------------

Format('%2.2n',1.115)=1.12

Format('%2.2n',1.125)=1.13

Format('%2.2n',1.135)=1.14

Format('%2.2n',1.145)=1.15

Format('%2.2n',1.155)=1.16

Format('%2.2n',1.165)=1.17

Format('%2.2n',1.175)=1.18

Format('%2.2n',1.185)=1.19

Format('%2.2n',1.195)=1.20

FormatFloat--------------------------------

FormatFloat('0.00',1.115)=1.12

FormatFloat('0.00',1.125)=1.13

FormatFloat('0.00',1.135)=1.14

FormatFloat('0.00',1.145)=1.15

FormatFloat('0.00',1.155)=1.16

FormatFloat('0.00',1.165)=1.17

FormatFloat('0.00',1.175)=1.18

FormatFloat('0.00',1.185)=1.19

FormatFloat('0.00',1.195)=1.20

FormatCurr--------------------------------

FormatCurr('0.00',1.115)=1.12

FormatCurr('0.00',1.125)=1.12

FormatCurr('0.00',1.135)=1.14

FormatCurr('0.00',1.145)=1.14

FormatCurr('0.00',1.155)=1.16

FormatCurr('0.00',1.165)=1.16

FormatCurr('0.00',1.175)=1.18

FormatCurr('0.00',1.185)=1.18

FormatCurr('0.00',1.195)=1.20