LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ZPXY
 
Posts: n/a
Default How batch calculations?

Hello all:

EXCEL has the function to input calculation results. Say A2=2, B2=3. If we
want to input C2 with A2+B2, then we just, with cursor on C2, need to do:
=A2+B2. The result 5 will input to C2.

Now my question is how to do batch calculation? Say:
A2=2, A3=3, A4=4, ....., An=n, .....
B2=4, B3=6, B4=8, ......, Bn=2n, ....
I want the C column is the summary of A column and B column:
C2=A2+B2, C3=A3+B3, C4=A4+B4, ....., Cn=An+Bn, .....

Because A and B columns are very long, it is too trouble to calculate one
by one.
What is the way to CALCULATE THEM IN A BATCH, just one step to calculate all
of them?

Thank you in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looping through a set of calculations Anand Excel Worksheet Functions 2 September 14th 05 07:12 PM
Calculations crossing multiple sheets Stephen McArthu Excel Discussion (Misc queries) 4 June 6th 05 04:35 PM
excel calculations lloyd8156 Excel Worksheet Functions 1 May 26th 05 07:11 PM
Calculations too long KRAMER Excel Worksheet Functions 1 May 18th 05 01:47 PM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"