Subtracting the smaller from the larger gives 7 - 3.4 = 3.6, and since the larger absolute value was 7, we give the result the same sign as 7, so 7 + (-3.4) = 3.6. The absolute values of 7 and -3.4 are 7 and 3.4. (-100) + (-0.05) = -(100 + 0.05) = -100.05Ģ) When adding numbers of the opposite signs, we take their absolute values, subtract the smaller from the larger, and give the result the sign of the number with the larger absolute value. We specify the absolute value of a number n by writing n in between two vertical bars: | n |.ġ) When adding numbers of the same sign, we add their absolute values, and give the result the same sign. The absolute value of a number is always a positive number (or zero). The number of units a number is from zero on the number line. The number line shown below is just a small piece of the number line from -4 to 4.įor any two different places on the number line, the number on the right is greater than the number on the left.Ībsolute Value of Positive and Negative Numbers The number line is a line labeled with positive and negative numbers in increasing order from left to right, that extends in both directions. The following mixed numbers are all equal: We may also write positive and negative numbers as fractions or mixed numbers. The sign of a number refers to whether the number is positive or negative, for example, the sign of -3.2 is negative, and the sign of 442 is positive. The sum of any number and its opposite is 0. We do not consider zero to be a positive or negative number. For example, the opposite of -12.3 is 12.3. Similarly, the opposite of any negative number is a positive number. Negative numbers are less than zero (see the number line for a more complete explanation of this). We write the opposite of a positive number with a negative or minus sign in front of the number, and call these numbers negative numbers. For each positive number, there is a negative number that is its opposite. Positive numbers are any numbers greater than zero, for example: 1, 2.9, 3.14159, 40000, and 0.0005. Multiplying positive and negative numbers Subtracting positive and negative numbers Another example is SUM(A1, A3, A5) which adds the numbers that are contained in cells A1, A3, and A5 (A1, A3, and A5 are arguments).Absolute value of positive and negative numbers For example, SUM(A1:A5) adds all the numbers in the range of cells A1 through A5. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function. The SUM function adds all the numbers that you specify as arguments. To switch between viewing the results and viewing the formulas, press CTRL+` (grave accent) on your keyboard.Or, click the Show Formulas button (on the Formulas tab).
In the worksheet, select cell A1, and then press CTRL+V. Subtracts 9000 from 15000 (which equals 6000)Īdds all number in the list, including negative numbers (net result is 16000) Select all of the rows in the table below, then press CTRL-C on your keyboard. Exampleįollow these steps to subtract numbers in different ways: Use the SUM function and convert any numbers that you want to subtract to their negative values. Note: There is no SUBTRACT function in Excel.
0 kommentar(er)
