Arithmetic_Operators_Precedence

Arithmetic_Operators - -7 Subtracts the value in cell F3 from the value i =B3-F3 Arithmetic Operations symbols and description of use P le E

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Sample Numbers 2 10 Enter Formula 3 21 =SUM(A2:A4) 10 5 9 =ROUND(B2-A3/A5,0) 7 25 =B2/A2*A4 =B5-A2*B2 =B3/A3 =B5/A4*A2-A4 =A2*(B5/(A4*A2)) =A4*A3-A4*A2 Do the Math: Enter your formula in column E th range of cells A2:B5 with the same number in t formula in column F. Example: The result of the when entered in column E equals 10, so put B2 since its value is 10.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
B2 hen put the cell location in the the cell to the right of the e formula in the D column 2 in column F to the right Enter Cell where value equals the result to the left
Background image of page 2
Sample Numbers > 10 1 0.6 12 3 Arithmetic Operation Arithmetic operator Example Description Parentheses ( ) 3 =E3/(F3+C3) Exponentiation ^ 1000 Raises the value in cell E3 by the value in cel =B3^F3 Multiplication * 6 Multiplies the value in cell B3 by the value in =B3*D3 Division / 4 Divides the value in cell E3 by the value in ce =E3/F3 Addition + 11 Adds the value in cell B3 to the value in cell C =B3+C3 Subtraction
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -7 Subtracts the value in cell F3 from the value i =B3-F3 Arithmetic Operations, symbols and description of use - P le E xcuse [M y D ear] [A unt S ally] Divides the value in cell E3 by the sum of the cell F3 and cell C3 ll F3 cell D3 ell F3 C3 in cell B3 ease e values in Order of Precedence Rules Formula Value A5=10, B5=20, C5=3 A5 Value B5 Value C5 Value Result 10 20 3 70 =A5+B5*C5 90 =(A5+B5)*C5 3.5 =A5/B5+C5 0.435 =A5/(B5+C5) 1.5 =A5/B5*C5 0.166667 =A5/(B5*C5) Order of Precedence Rule Multiplication before addition Division before addition Expression inside parentheses executed before expression outside Expression inside parentheses executed before expression outside Two operators at the same precedence level, leftmost operator evaluated first Expression inside parentheses executed before expression outside...
View Full Document

This note was uploaded on 06/25/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.

Page1 / 6

Arithmetic_Operators - -7 Subtracts the value in cell F3 from the value i =B3-F3 Arithmetic Operations symbols and description of use P le E

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online