Microsoft Excel is the world’s most powerful tool for data computation and calculation. Microsoft Excel provides us with built-in functions and tools by which we can solve our Complex problems within seconds and these problems can be solved by one click. Most of the time we face a problem of negative numbers which impacts our results.
In this tutorial, we will learn how to convert the negative numbers into positive numbers. There are two different methods by which we can convert negative numbers into positive.
Method 1 – Multiply with negative 1 number
This method allows us to convert a negative number into positive on multiplying the integer value by -1. There is only one limitation: it will convert the positive numbers into negative. We must be vigilant that all numbers should have negative signs which we want to convert to positive The formula is
=value 1 * value in negative
Step 1 – select the cell and multiply
- Select any cell, in this case we selected E2, and applied the formula.
- Type the formula.
- As soon as you press the enter key.
- It will convert all the numbers into positive integer values.
Animation is given above.
Method 2 – Use ABS function
This method allows us to convert a negative number into positive by using the ABS function. The ABS function in Excel returns the absolute value of a number. The function converts negative numbers to positive numbers while positive numbers remain unaffected
=ABS(Number)
The steps are given below;
Step 1 – select the cell and apply the formula
- Select the cell where you wish to convert the numbers.
- In this case we selected E2 for absolute function.
- Type = and write ABS function . In this case we selected the whole column value using @ column name and square bracket.
- As soon as you press the enter key. The absolute function converted the negative values to positive
- The flash fill function filled the rest of the values.
Animation is given above.
Hence ,We converted all the negative values to positive by using absolute function. It only converts the value having negative sign and all the positive values remain the same.