The mathematical operators are shown below
(-) | Negation (negative number) |
(%) | Percent |
(^) | Exponentiation (to the power of) |
(* And /) | Multiplication and division |
(+ And -) | Addition and subtraction |
(&) | Addition and subtraction |
( = < > <= >= <>) | Comparison |
They are listed in decreasing order of priority starting with negation which has the highest priority (done first) and ending with comparison which has the lowest (done last). If a formula contains operators with the same
priority, they are evaluated from left to right.
If you want to alter the order of evaluation, use parentheses (brackets) to group expressions. Any parts of a formula that are in parentheses are done first.
It is important to fully understand the order in which Excel carries out a calculation.
- Click in B3 and type =2*9+12/6-4
- Press the Enter key.
- Make sure that you understand why the answer is 16.
0 comments:
Post a Comment
comment here