This topic has been archived. It cannot be replied.
-
工作学习 / 求学深造 / all high hand~~ an urgent quesion(stupid as well): i am using EXCEL to do a calculation.what i am going to do is:
all the numbers in column C divided by the number in column D, and the result should go to column E.
can any high hand tell me how to do that? thank you very much.
-foureyecatcat(西北的包子);
2002-11-13
{198}
(#851988@0)
-
在E那里的第一格填写 = c1/d1,回车，再点第一格子， 然后鼠标移动到第一格的右下方，当出现一个+号时，点住不放往下拉，拉到所有数据完了就搞定了
-oceandeep(北极熊® Zzz Zzz);
2002-11-13
(#851993@0)
-
thank you. i did what you said. but column E turn out to be c1/d1, c2/ d1,c3/d3....etc. what i need in column E is in percentage.
-foureyecatcat(西北的包子);
2002-11-13
(#852002@0)
-
大概你漏了等号吧，要百分比，点住整个E列，然后右键点一下，出来一个菜单，选“设置单元格式”，数字那个对话面，选百分比，然后还可以选小数点后面几位
-oceandeep(北极熊® Zzz Zzz);
2002-11-13
(#852004@0)
-
GAO DING! THANK YOU ! QIN REN!
-foureyecatcat(西北的包子);
2002-11-13
(#852014@0)
-
不行了，撑不住了，我得睡觉了，你还不好的话，随便抓这里的人，估计10个9个会
-oceandeep(北极熊® Zzz Zzz);
2002-11-13
(#852011@0)
-
GOOD NIGHT. GOOD SLEEP BEAR
-foureyecatcat(西北的包子);
2002-11-13
(#852015@0)