|
|
 | | From: | CHong | | Subject: | 对EXCEL的强大功能有点菜啦.请教个问题呢..谢谢 | | Date: | Tue, 18 Jan 2005 16:39:10 +0800 |
|
|
 | 一个表中有许多的数字单元格,现在想对这一部分的单元格进行数学计算
比如对这一部分的单元格全部除以8或者加6等的此类操作,
有什么简便的方法或函数吗?
谢谢呢
|
|
| | From: | =?gb2312?B?s/65rbP+tcM=?= | | Subject: | =?gb2312?B?UmU6ILbURVhDRUy1xMe/tPO5psTc09C147LLwLIux+u9zLj2zsrM4g==?= | | Date: | Tue, 18 Jan 2005 19:21:49 +0800 |
|
|
| This is a multi-part message in MIME format.
------=_NextPart_000_0012_01C4FD92.F4F8DFE0
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
=B3=CB8:=D4=DA=D2=BB=B8=F6=B5=A5=D4=AA=B8=F1=C0=EF=CA=E4=C8=EB8,=D1=A1=D6=
=D0=A1=A2=B8=B4=D6=C6=A3=AC=D4=DA=D2=AA=B3=CB=B5=C4=CA=FD=BE=DD=C9=CF=D3=D2=
=BC=FC=A1=A2=D1=A1=D4=F1=D0=D4=D5=B3=CC=F9=A1=A2=CA=FD=BE=DD=A1=A2=B3=CB
=D2=D4=B4=CB=C0=E0=CD=C6
"CHong" =
=D0=B4=C8=EB=CF=FB=CF=A2=D0=C2=CE=C5:OZRP4kT$EHA.2568@TK2MSFTNGP10.phx.gb=
l...
=
=D2=BB=B8=F6=B1=ED=D6=D0=D3=D0=D0=ED=B6=E0=B5=C4=CA=FD=D7=D6=B5=A5=D4=AA=B8=
=F1,=CF=D6=D4=DA=CF=EB=B6=D4=D5=E2=D2=BB=B2=BF=B7=D6=B5=C4=B5=A5=D4=AA=B8=
=F1=BD=F8=D0=D0=CA=FD=D1=A7=BC=C6=CB=E3
=
=B1=C8=C8=E7=B6=D4=D5=E2=D2=BB=B2=BF=B7=D6=B5=C4=B5=A5=D4=AA=B8=F1=C8=AB=B2=
=BF=B3=FD=D2=D48=BB=F2=D5=DF=BC=D36=B5=C8=B5=C4=B4=CB=C0=E0=B2=D9=D7=F7,
=
=D3=D0=CA=B2=C3=B4=BC=F2=B1=E3=B5=C4=B7=BD=B7=A8=BB=F2=BA=AF=CA=FD=C2=F0?=
=D0=BB=D0=BB=C4=D8=20
------=_NextPart_000_0012_01C4FD92.F4F8DFE0
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
size=3D2>=B3=CB8:=D4=DA=D2=BB=B8=F6=B5=A5=D4=AA=B8=F1=C0=EF=CA=E4=C8=EB8,=
=D1=A1=D6=D0=A1=A2=B8=B4=D6=C6=A3=AC=D4=DA=D2=AA=B3=CB=B5=C4=CA=FD=BE=DD=C9=
=CF=D3=D2=BC=FC=A1=A2=D1=A1=D4=F1=D0=D4=D5=B3=CC=F9=A1=A2=CA=FD=BE=DD=A1=A2=
=B3=CB
size=3D2>
size=3D2>=D2=D4=B4=CB=C0=E0=CD=C6
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #ff0000 2px solid; MARGIN-RIGHT: 0px">
"CHong" <duyd(removethis)@163.com>=20
=
=D0=B4=C8=EB=CF=FB=CF=A2=D0=C2=CE=C5:OZRP4kT$EHA.2568@TK2MSFTNGP10.phx.gb=
l... =D2=BB=B8=F6=B1=ED=D6=D0=D3=D0=D0=ED=B6=E0=B5=C4=CA=FD=D7=D6=B5=
=A5=D4=AA=B8=F1,=CF=D6=D4=DA=CF=EB=B6=D4=D5=E2=D2=BB=B2=BF=B7=D6=B5=C4=B5=
=A5=D4=AA=B8=F1=BD=F8=D0=D0=CA=FD=D1=A7=BC=C6=CB=E3
=B1=C8=C8=E7=B6=D4=
=D5=E2=D2=BB=B2=BF=B7=D6=B5=C4=B5=A5=D4=AA=B8=F1=C8=AB=B2=BF=B3=FD=D2=D48=
=BB=F2=D5=DF=BC=D36=B5=C8=B5=C4=B4=CB=C0=E0=B2=D9=D7=F7,
=D3=D0=CA=B2=C3=
=B4=BC=F2=B1=E3=B5=C4=B7=BD=B7=A8=BB=F2=BA=AF=CA=FD=C2=F0?
=D0=BB=D0=BB=
=C4=D8=20
------=_NextPart_000_0012_01C4FD92.F4F8DFE0--
|
|
| | From: | CHong | | Subject: | Re: 对EXCEL的强大功能有点菜啦.请教个问题呢..谢谢 | | Date: | Wed, 19 Jan 2005 08:39:04 +0800 |
|
|
| 咦..真的行呢..嘿嘿
真是太好了,太感谢了啦..呵
"楚弓楚得" 写入消息新闻:Okvnq$U$EHA.3924@TK2MSFTNGP15.phx.gbl...
乘8:在一个单元格里输入8,选中、复制，在要乘的数据上右键、选择性粘贴、数据、乘
以此类推
"CHong"
|
|
|
