3 Types of 'cell ranges' to be come aquainted with. Row, Column and Rectangular range. Details below.
If you're just learning Spreadsheets and Excel, this is the essential part of the tutorial where you will learn about doing calculations.
If you want to add B1 to B2 and store the answer in B3, type this formula:
If you're wanting to subtract S1 from S2 (answer in S3), type this:
Say you want to multiply O1 to O2, type:
Now dividing D1 by D2 results in D3- type:
Finally if F1 has the value 2, and F2 the value of 3, and you want to take 2 to the 3rd power, do this:
TIP: Always use cell addresses when possible to do calculations. If you use numbers, you would have to retype the formula every time you change a cell that is part of the calcuation. If you use cell addresses and change a value that is part of a formula, the answer is recalculated automatically ;)
Heres a table that will help you with more complex equations and remember 'the order of operations' take effect. Remember the saying, "Please Excuse My Dear Aunt Sally?" (Parenthesis, Exponents, Multiply, Division, Add, Subtract)
No Comments for this page.