![]() ![]() Jumping down to the second problem on our and negative plus a positive worksheet you can see that this time we have a positive 1 plus a negative 8. So negative 1 plus negative 5 is negative 6. We’re going to add our number plus negative 5 so we’re going to add negative 1 and negative 5 together and that’s going to give us 6 and then because they are both negative our answer also has to be negative. ![]() Our answer will also be negative so all you have to do is add negative 1. ![]() This is a negative 1 and this is a negative 5. So you add the numbers together then because the signs are the same, you keep that sign. Our rule is you will add the two negatives up. Now you will notice that both of these numbers are already negative, so the negative 1 and the negative 5 are both negative. ![]() Our first problem gives us negative one plus negative five. The benefit of the second method is that, if you want a list of only positive values and the original list contains a mix of positive and negative values, the second method will ensure that all values end up being positive, whereas Method 1 and 2 will simply reverse the sign of each number, regardless of whether or not all of the values in the list are positive, negative, or a mix of the two.First of all our first problem gives us negatives. The benefit of the first method is that it can be used to go from positive to negative or negative to positive. I prefer Method 3 just because I can do it in a couple seconds using keyboard shortcuts that I am familiar with. Now, delete the second column that has all of the functions and you are done.Then select the original column of numbers and hit Alt + E + S + V and Enter (this will copy-paste-special values over the original list):.Now, you can stop here if you don't mind having two columns of data, one containing the raw data and the other containg functions, or, you can continue to make it one list - copy the new column of numbers (the positive ones):.Copy the function down the entier list by selecting the first cell, B1, and double-clicking the bottom-right side of the cell:.Note that the cell reference refers to the first number in the list. Enter =ABS(Cell Reference ) into the first cell next to the list of numbers:.Whereas Method 1 may cause you to end up with mixed results if you had some negative and some positive values in the starting list, this method will only allow for positive numbers to be created, no matter what. This will create a series of positive numbers from any set of negative numbers or a mix of negative and positive numbers. You can also use the ABS() or absolute value function to return a number without its sign. Method 3 - ABS() Function to Convert Negative Value to Positive Values Remember to keep -1 the same since multiplying a positive number by a negative number will create a negative result. To convert any series of positive numbers to negative numbers, simply follow the exact same steps as in Method 1 above the only difference is that you will start with positive numbers in the original list this time. Method 2 - Convert Positive Values to Negative Values Now, you have a colum of positive values:.Select the option Multiply and then hit OK:.Right-click over the negative numbers and click Paste Special:.Copy the cell with the -1, just select the cell and hit Ctrl + C:.Add a cell with -1 in it near your negative numbers:.You can use the "paste special" method to change numbers from negative to positive or positive to negative. Method 1 - Convert Negative Values to Positive Values I will show you a few ways to change negative numbers to positive numbers and back again in Excel.ĭon't forget to download the accompanying workbook so you can follow along with the tutorial. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |