![]() |
|
|||||||
![]() |
|
microsoft excel help! 10 points to best answer!?
|
![]() |
LinkBack | Thread Tools | ![]() |
Display Modes | ![]() |
|
|||
|
how do you multiply/divide/add/subtract one cell from another? like if i entered 6 in A1 and 2 in B2, then how do i make C3=A1/B2, and then 2 automatically pops up in C3? besides dividing it by myself everytime?
|
| Links |
|
|
|
|||
|
You basically just answered your own question. Ok, you have 6 in A1 and 2 in B2, type "=A1/B2" in C3, press enter and presto! There's your answer. That's it. If you want to make calculations in any cell just put the equal sign in first and what cells and type of operators you want and that's it.
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|