# Opposite of ABS Function in Excel (5 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

When you need to convert any negative values into positive ones then you may use the ABS function in Excel. But, I will explain today how to use the opposite of the ABS function in Excel. Which means that Iâ€™m going to convert any values into negative one.

## Opposite of ABS Function in Excel: 5 Examples

Here, Iâ€™m going to demonstrate 5 suitable methods of how to use the opposite of the ABS function in Excel. For your better understanding, I will use a sample dataset. Which has 2 columns. Those are Categories and Expenses\Income. The sample dataset is given below.

### 1. Use of Subtraction Operator with ABS Function in Excel

Here, you know that the ABS function will return all absolute values or positive values. So, if you use a Minus sign (-) before the ABS function then all the positive values will convert into a negative one. Now, letâ€™s talk about the steps.

Steps:

• Firstly, you have to select a blank cell D5 where you want to keep the result.
• Secondly, you should use the corresponding formula in the D5 cell.
`=-ABS(C5)`

Here, in this formula, the ABS function will convert the C5 cell value into an absolute one and then the Minus sign (-) will again convert it into a negative one.

• Subsequently, you must press ENTER to get the result.

Finally, you will see the converted negative values.

• Now, I will copy the same formula using relative cell references. To do this, select cell D5. A square box will be shown in the bottom-right corner of cell D5, it is called the Fill Handle icon. Click the Fill Handle icon, hold it, and drag until you reach cell D13.
• Then, release the Mouse cursor.

Lastly, you will get all the converted negative values.

Read More: How to Sum Absolute Value in Excel

### 2. Applying ABS Function & Multiplication Operator

Here, you can apply the Multiplication operator (*) with the ABS function for getting the opposite result which will give the ABS function in Excel. Now, letâ€™s talk about the steps.

Steps:

• Firstly, you have to select a blank cell D5 where you want to keep the result.
• Secondly, you should use the corresponding formula in the D5 cell.
`=ABS(C5)*-1`

Here, in this formula, the ABS function will convert the C5 cell value into an absolute one and then I have multiplied the output with -1 to convert it into a negative one.

• After that, you have to drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells D6:D13. Or you can double-click on the Fill Handle icon.

Finally, you will get all the converted negative values.

Read More: How to Get Absolute Value in Excel

### 3. Employing IF Function in Excel

You can apply the IF function to find out the opposite result instead of using the ABS function in Excel. Furthermore, you can modify this function for different types of results according to your preference. The steps are given below.

Steps:

• Firstly, you have to select a blank cell D5 where you want to keep the result.
• Secondly, you should use the corresponding formula in the D5 cell.
`=IF(C5<0,C5,C5*-1)`

Formula Breakdown

Here, the IF function will return a logical test result.

• Firstly, C5<0 denotes the logical test. This test will check whether the cell value of C5 is less than 0 or not.
• Secondly, C5â€”> Â when the cell value is less than 0 which means the logic is true then it will return the cell value of C5.
• Lastly, C5*-1 â€”> when the cell value is greater than 0 then it will do this operation. In this operation, the cell value will multiply with -1.

• After that, you must press ENTER to get the result.
• Now, you can drag the Fill Handle icon to AutoFill the corresponding data in the rest of the cells D6:D13.

Lastly, you will get all the converted negative values.

### 4. Multiplying with Negative 1

You can apply the Multiplication (*) operator as the opposite of the ABS function in Excel. Here, with this formula, you can convert the positive values into negative ones. On the other hand, the negative values will turn into positive ones. The steps are given below.

Steps:

• Firstly, you have to select a different cell D5 where you want to see the result.
• Secondly, you should use the following formula in the D5 cell.
`=C5*-1`

Here, the cell value of C5 will multiply with -1.

• Subsequently, you must press ENTER to get the result.

• After that, you can double-click on the Fill Handle icon to AutoFill the corresponding data in the rest of the cells D6:D13.

At this time, you will get the following result. Here, if you notice deeply then you can see that the positive values of the C column become negative and the negative values become positive.

### 5. Use of VBA to Get Opposite of ABS Function

You can employ the VBA code for getting the opposite result which you will get by using the ABS function in Excel. The steps are given below.

Steps:

• Firstly, you have to choose the Developer tab >> then select Visual Basic.

• Now, from the Insert tab >> you have to select Module.

• After that, write down the following Code in the Module.
``````Sub Opposite_ABS()
Â Â Â Â Dim my_cell_value As Range
Â Â Â Â For Each my_cell_value In Range("C5:C13")
Â Â Â Â Â Â Â Â my_cell_value.Offset(0, 1) = -Abs(my_cell_value.Value)
Â Â Â Â Next my_cell_value
End Sub``````

Code Breakdown

• Here, I have created a Sub Procedure named Opposite_ABS.
• Next, I have declared a variable my_cell_value as Range.
• After that, I used a For Each Loop to apply the calculation to all defined cells.

• Now, Save the code then go back to Excel File.
• Then, from the Developer tab >> you have to select Macros.

AÂ dialog boxÂ ofÂ MacroÂ will appear.

• Now, you need to select Macro (Opposite_ABS) and click on Run.

At this time, you can see the converted negative values.

## ðŸ’¬ Things to Remember

• All the methods will convert any values into negative ones except method 4. Which will convert the negative to positive and positive to negative.

## Practice Section

Now, you can practice the explained method by yourself.

## Conclusion

I hope you found this article helpful. Here, I have explained 5 methods of how to use the opposite of ABS function in Excel.Â Please, drop comments, suggestions, or queries if you have any in the comment section below.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Musiha Mahfuza Mukta

Musiha Mahfuza Mukta, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, has been working with the ExcelDemy project for 1.5 years. She has written over 97+ articles for ExcelDemy. Currently, she is working as the Excel and VBA Content Developer, creates contents, solves user problems, writes articles etc. Her work and learning interest varies from Microsoft Office Suites, and Excel to Data Analysis, and developing Excel Applications with VBA codes.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF