Now try editing the formula in B3. Put parentheses round different parts of the expression, as suggested below, and see how they affect the answer.
When you have more than one pair of brackets in a formula, Excel displays them in different colours on the formula bar.
| Formula | Answer |
| =(2*9)+12/(6-4) | 24 |
| =2*(9+12)/6-4 | 3 |
| =(2*9+12)/6-4 | 1 |
| =2*(9+12/(6-4)) | 30 |
0 comments:
Post a Comment
comment here