Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
excel calculations | Excel Worksheet Functions | |||
Calculations too long | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |