newsgroups-index (beta)

Current group: microsoft.public.cn.excel

=?gb2312?B?1PXDtLLFxNzKubbgzrvQocr9tcS6zdPry8TJ4c7lyOu687XEus294bn70rs=?=

=?gb2312?B?1PXDtLLFxNzKubbgzrvQocr9tcS6zdPry8TJ4c7lyOu687XEus294bn70rs=?=  
clm7888
 Re: 怎么才能使多位小数的和与四舍五入后的和结果一致  
喻箐
From:clm7888
Subject:=?gb2312?B?1PXDtLLFxNzKubbgzrvQocr9tcS6zdPry8TJ4c7lyOu687XEus294bn70rs=?=
Date:Fri, 7 Jan 2005 19:39:17 +0800
This is a multi-part message in MIME format.

------=_NextPart_000_004D_01C4F4F0.9366C210
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable

A B C D=20
1 187.764377512385 187.76 187.76 =20
2 188.594217182877 188.59 188.59 =20
3 189.425733318912 189.43 189.43 =20
4 190.264942188848 190.26 190.26 =20
5 191.105860133033 191.11 191.11 =20
6 191.954503564122 191.95 191.95 =20
7 192.800888967393 192.80 192.80 =20
8 193.654032901074 193.65 193.65 =20
9 194.514951996661 194.51 194.51 =20
10 195.371662959246 195.37 195.37 =20
11 196.236182567841 196.24 196.24 =20
12 197.104527675704 197.10 197.10 =20
13 197.976715210669 197.98 197.98 =20
=BA=CF=BC=C6 2506.768596178770 2506.77 2506.75 =20


Excel=B1=ED=D6=D0=A3=ACB=C1=D0=CA=FD=BE=DD=D3=C9=BC=C6=CB=E3=C7=F3=B5=C3=A3=
=AC=C9=E8=D6=C3=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD=BA=F3=CF=D4=CA=BE=CE=AA=
C=C1=D0=CA=FD=BE=DD=A3=AC=B5=AB=CA=B5=BC=CA=C9=CF=CB=FC=C8=D4
=C8=BB=CA=C7B=C1=D0=B5=C4=CA=FD=D6=B5=A3=ACB=C1=D0=A1=A2C=C1=D0=BA=CF=BC=C6=
=B5=C4=BD=E1=B9=FB=CA=C7=D2=BB=D6=C2=B5=C4=A3=AC=CB=E4=C8=BBD=C1=D0=B5=C4=
=CA=FD=BE=DD=BF=B4=C6=F0=C0=B4=D3=EBC=C1=D0=D2=BB=D1=F9=A3=AC=B5=AB
=CB=FC=CA=C7=D6=BB=D3=D0=C1=BD=CE=BB=D0=A1=CA=FD=B5=C4=CA=FD=D7=D6=A3=AC=BA=
=CF=BC=C6=B5=C4=BD=E1=B9=FB=D3=EBC=C1=D0=D3=D0=CE=F3=B2=EE=A3=AC=B2=EE0.0=
2=A1=A3=D4=DA=CA=B5=BC=CA=D4=CB=D3=C3=D6=D0=D4=F5=C3=B4=B2=C5=C4=DC
=CA=B9B=C1=D0=CA=FD=BE=DD=D4=DA=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD=BA=F3=
=A3=AC=BC=C6=CB=E3=B5=C4=BD=E1=B9=FB=D3=EBD=C1=D0=D2=BB=D6=C2=A1=A3=A3=A8=
D=C1=D0=B5=C4=BD=E1=B9=FB=B2=C5=CA=C7=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD=

=BA=F3=D0=E8=D2=AA=B5=C4=BD=E1=B9=FB=A3=A9

------=_NextPart_000_004D_01C4F4F0.9366C210
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable










cellPadding=3D0 width=3D360 border=3D0 x:str>

1408"=20
width=3D44>
5248"=20
width=3D164>
2432"=20
width=3D76>
2432"=20
width=3D76>











































































style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: =
33pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; =
BACKGROUND-COLOR: transparent"=20
width=3D44 height=3D19>A		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 123pt; =
BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20
width=3D164> =
size=3D2>       B   &nb=
sp;           &nbs=
p;   		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; =
BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20
width=3D76>   C		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 57pt; =
BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"=20
width=3D76>  D
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>1		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"187.76437751238501">size=3D2>187.764377512385=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"187.76437751238501">187.76 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"187.76">187.76 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>2		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"188.594217182877">size=3D2>188.594217182877=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"188.594217182877">188.59 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"188.59">188.59 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>3		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"189.42573331891168">size=3D2>189.425733318912=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"189.42573331891168">189.43 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"189.43">189.43 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>4		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"190.26494218884801">size=3D2>190.264942188848=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"190.26494218884801">190.26 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"190.26">190.26 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>5		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.10586013303347">size=3D2>191.105860133033=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.10586013303347">191.11 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.11">191.11 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>6		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.95450356412201">size=3D2>191.954503564122=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.95450356412201">191.95 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"191.95">191.95 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>7		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"192.80088896739335">size=3D2>192.800888967393=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"192.80088896739335">192.80 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"192.8">192.80 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>8		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"193.65403290107406">size=3D2>193.654032901074=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"193.65403290107406">193.65 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"193.65">193.65 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>9		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"194.51495199666101">size=3D2>194.514951996661=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"194.51495199666101">194.51 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"194.51">194.51 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>10		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"195.37166295924646">size=3D2>195.371662959246=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"195.37166295924646">195.37 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"195.37">195.37 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>11		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"196.23618256784118">size=3D2>196.236182567841=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"196.23618256784118">196.24 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"196.24">196.24 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>12		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.10452767570385">size=3D2>197.104527675704=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.10452767570385">197.10 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.1">197.10 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19 x:num>13		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.97671521066877">size=3D2>197.976715210669=20
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.97671521066877">197.98 =
 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"197.98">197.98 =
style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: =
windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent"=20
height=3D19>=BA=CF=BC=C6		 style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"2506.7685961787661" =
x:fmla=3D"=3DSUM(B2:B14)"> size=3D2>2506.768596178770 		style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"2506.7685961787661" =
x:fmla=3D"=3DSUM(C2:C14)"> size=3D2>2506.77 		style=3D"BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: =
windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt =
solid; BACKGROUND-COLOR: transparent"=20
align=3Dright x:num=3D"2506.75" x:fmla=3D"=3DSUM(D2:D14)">size=3D2>2506.75=20

 

Excel=B1=ED=D6=D0=A3=ACB=C1=D0=CA=FD=BE=DD=D3=C9=BC=C6=CB=E3=C7=F3=B5=
=C3=A3=AC=C9=E8=D6=C3=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD=BA=F3=CF=D4=CA=BE=
=CE=AAC=C1=D0=CA=FD=BE=DD=A3=AC=B5=AB=CA=B5=BC=CA=C9=CF=CB=FC=C8=D4
=C8=
=BB=CA=C7B=C1=D0=B5=C4=CA=FD=D6=B5=A3=ACB=C1=D0=A1=A2C=C1=D0=BA=CF=BC=C6=B5=
=C4=BD=E1=B9=FB=CA=C7=D2=BB=D6=C2=B5=C4=A3=AC=CB=E4=C8=BBD=C1=D0=B5=C4=CA=
=FD=BE=DD=BF=B4=C6=F0=C0=B4=D3=EBC=C1=D0=D2=BB=D1=F9=A3=AC=B5=AB
=CB=FC=
=CA=C7=D6=BB=D3=D0=C1=BD=CE=BB=D0=A1=CA=FD=B5=C4=CA=FD=D7=D6=A3=AC=BA=CF=BC=
=C6=B5=C4=BD=E1=B9=FB=D3=EBC=C1=D0=D3=D0=CE=F3=B2=EE=A3=AC=B2=EE0.02=A1=A3=
=D4=DA=CA=B5=BC=CA=D4=CB=D3=C3=D6=D0=D4=F5=C3=B4=B2=C5=C4=DC
=CA=B9B=C1=
=D0=CA=FD=BE=DD=D4=DA=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD=BA=F3=A3=AC=BC=C6=
=CB=E3=B5=C4=BD=E1=B9=FB=D3=EBD=C1=D0=D2=BB=D6=C2=A1=A3=A3=A8D=C1=D0=B5=C4=
=BD=E1=B9=FB=B2=C5=CA=C7=B1=A3=C1=F4=C1=BD=CE=BB=D0=A1=CA=FD
=BA=F3=D0=
=E8=D2=AA=B5=C4=BD=E1=B9=FB=A3=A9


------=_NextPart_000_004D_01C4F4F0.9366C210--
From:喻箐
Subject:Re: 怎么才能使多位小数的和与四舍五入后的和结果一致
Date:Sat, 8 Jan 2005 12:22:52 +0800
这是累计误差


"clm7888" 写入消息新闻:uNi%23C2K9EHA.3416@TK2MSFTNGP09.phx.gbl...
A B C D
1 187.764377512385 187.76 187.76
2 188.594217182877 188.59 188.59
3 189.425733318912 189.43 189.43
4 190.264942188848 190.26 190.26
5 191.105860133033 191.11 191.11
6 191.954503564122 191.95 191.95
7 192.800888967393 192.80 192.80
8 193.654032901074 193.65 193.65
9 194.514951996661 194.51 194.51
10 195.371662959246 195.37 195.37
11 196.236182567841 196.24 196.24
12 197.104527675704 197.10 197.10
13 197.976715210669 197.98 197.98
合计 2506.768596178770 2506.77 2506.75


Excel表中，B列数据由计算求得，设置保留两位小数后显示为C列数据，但实际上它仍
然是B列的数值，B列、C列合计的结果是一致的，虽然D列的数据看起来与C列一样，但
它是只有两位小数的数字，合计的结果与C列有误差，差0.02。在实际运用中怎么才能
使B列数据在保留两位小数后，计算的结果与D列一致。（D列的结果才是保留两位小数
后需要的结果）
   
Copyright © 2006 newsgroups-index   -   All rights reserved   -   Impressum