how do you multiply/divide/add/subtract one cell from another? approaching if i enter 6 surrounded by A1 and 2 surrounded by B2, consequently how do i be paid C3=A1/B2, and next 2 automatically pops up surrounded by C3? besides dividing it by myself everytime?
Answers: You primarily a moment ago answered your own cross-question. Ok, you hold 6 within A1 and 2 contained by B2, type "=A1/B2" contained by C3, press enter and presto! There's your answer. That's it. If you want to craft calculation surrounded by any cell a moment ago put the equal sign within first and what cell and type of operator you want and that's it.
Yeah, what dude said.
If you entail to do it within a bunch of cell, you can simply use (for example) "saturate down" and the formula will move, and the cell reference will be updated so that they point to equal column on the unusual procession.
at C3, click "Insert" at the verbs down menu, afterwards pick "function".
In the function category schedule, pick"math & trig", later pick the function on the right roll, such as : sum, product", as you requirement it.
Hope this sustain. Then you can copy this cell after ancient it to the full columm