Combining Arithmetic Operators
Combining Arithmetic Operators
The basic operators you've just met can be combined to make more complex calculations. For example, you can add to cells together, and multiply by a third one. Like this:
= A1 + A2 * A3
Or this:
= A1 + A2 - A3
And even this:
=SUM(A1:A9) * B1
In the above formula, we're asking Excel to add up the numbers in the cells A1 to A9, and then multiply the answer by B1. You'll get some practise with combining the operators shortly. But there's something you need to be aware of called Operator Precedence.View Docs
Posted by paiya
on 05:06.
Filed under
Spreadsheet Tutorials
.
You can follow any responses to this entry through the RSS 2.0