Xilin wrote:
Hello All:
In EXCEL, Supoose
A1=1, A2=2, A3=3, ...., An=n, ...
B1=11, B2=22, B3=33, ..., Bn=nn, ..
I want to input the addition of above A & B into C, i.e.:
C1=A1+B1, C2=A2+B2, C3=A3+B3, .... Cn=An+Bn, ....
Because columns A & B are very long, if calculate them
one by one will be time consuming. What is the way to calculate
all elements in a single step or batch calculation?
Thanks! Xilin
<<::SNIP::>>
Hmm, well, first, this is the **Web Developer's** Virtual Library discussion
group, keywords there being "Web Developer," not the Excel User's Group.
Second, this is an English language group, and whatever character set you're
using causes my email client to prompt me to install a Chinese character set
when replying to your messages. When I refuse, the reply message comes up in
a large monospaced font. Please switch your character set when corresponding
with the group, and try to keep your questions within at least shouting
distance of the universe of topics concerning Web development. It's a pretty
large universe, but it is nonetheless finite, and Excel is fairly well
completely beyond its boundaries.
That said, I don't know that there is a way to achieve a single-step
computation of the nature you are describing. Given that you wish individual
discrete values in each C cell, you are going to have to perform the
individual calculations for each pair of addends to produce the desired
discrete sum for each row. You do not state what further processing is to be
done, but there may be combinatorial equations available which would be
appropriate. (I only include this because your premise vaguely resembles
some kind of factorial computation. Very vaguely.)
Please see this page http://www.j-walk.com/ss/help/ for spreadsheet help. In
particular, peruse the "Excel newsgroups" and "Excel mailing lists" areas to
find sources for information more appropriate to your query than a Web
developer's mailing list. Thank you.
Cheers,
Scott
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
