How to make excel auto fill up the value based on the value for others column?

What function should i use to do the following task?





If i fill in Column A and Column B, how to make Column C value is automatically fill up based on the value for column A and column B?|||Autofill:


type 1 on A1 and 2 on B1.


Highlight A1:B1 range, grab the Fill-handle and Drag to C1.


Cell C1 will show 3 as the value.


Now repeat above for values of 2 on A1 and 4 on B1. C1 will display 6 (this is the Trend).


Try different combinations, observe the results.


Autofill is not a function.|||It's not a function, you just type in the formula you want.





So if in A1 you have 10 and in B1 you have 20 then:


type in C1 the following formulas and see what you get





=A1+B1


=A1*B1


=B1/A1


=A1^2





etc.





If you want to copy this down column c, then you can copy the formula you have and paste it using ctrl+c and ctrl+v just like other windows applications. The difference is that excel will modify the formula to make it relevant to the new location that you paste it into.|||Put a formula into the cell in column C. Once you place the formula into the first cell, you can use the drag and copy feature to copy the formula to all the cells in Column C.|||You can use concatinate function or if function as the case may be.