How To Introduce Arithmetic Operators In Excel For Mac


show more Introducing arithmetic operators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Introducing arithmetic operators

Many Excel formulas include arithmetic operators, such as the Plus sign and the Minus sign. But Excel doesn't just read your formula from left to right and take the operations in order; instead, Excel has a strict order in which it performs the operations. This worksheet displays the list of operators you can use in Excel and the order in which it processes them. I'll explain what the symbols mean and how they work within formulas. First, Excel checks whether a value is negative. Then it checks if a value is expressed as a percentage. If a value is expressed as a percentage, then Excel treats it as if it were divided by 100.

In other words, 75% is exactly the same as 0.75. So as an example, let's say that we have just the value -3, which is displayed as -3. If you have the value 75 percent, you type in 75 and then a percent sign, and you have the value 75%. That's also displayed here on the formula bar. If you were to type a formula where you multiplied 4 by 75%, so that woul...

Introducing arithmetic operators
Video duration: 4m 13s 6h 32m Beginner

Viewers:

Introducing arithmetic operators provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...