This topic has been archived. It cannot be replied.
-
工作学习 / 专业知识杂谈 / 请教个简单的EXCEL问题,有一列数字(有公式的)是正的,用什么FUNCTION可以让这一列一次就变成负数呢? 多谢.
-gingercat(true colors);
2006-11-16
(#3322707@0)
-
=yun()
-flyingsnail(Flying Snail);
2006-11-16
(#3322757@0)
-
thank u. :D
-gingercat(true colors);
2006-11-16
(#3324357@0)
-
SORRY,好象不大对吧,我找不到这个FUNCTION啊 YUN?? 能不能再指点一下.
-gingercat(true colors);
2006-11-20
(#3329563@0)
-
:) i use this one a lot.
-relax06(relax);
2006-11-20
(#3329610@0)
-
怎么我用了这个后出来的结果是#NAME? 是我哪里做错了吗? 真晕了.
-gingercat(true colors);
2006-11-21
(#3331440@0)
-
If you have a column of A1, A2,... Can you just create another column B1, B2 .. and use =-A1 at the cell of B1, then copy B1 to every cell of your other cells such as B2, B3,.... I guess they meant =晕() btw.
-xfile(xfile);
2006-11-20
(#3329845@0)
-
use another cell, input -1, then copy/paste special/mulitiply to the area you need to be changed
-erin_mills(再别康桥);
2006-11-22
(#3335376@0)
-
b1=a1*(-1), then click b2 and apply to all collumns
-dddddmmmmm(Chinese-moving-west);
2006-12-23
(#3392322@0)