change negative values to positive value and separate negative and positive numbers in excel
In this video you will see how to change negative values into positive values and How to separate negative values and positive values in Excel
Formulas
Change all negative values into positive:
=ABS(H2)
(make sure to change the cell reference like for example i gave H2,but you can change it to where your value is)
-------------------------------------------------------------------
Display only positive values (note: use greater than symbol as I am not allowed to put the greater then symbol here
=IF($H2please use greater than symbol=0,$H2,"")
(make sure to change the cell reference like for example i gave H2,but you can change it to where your value is)
-------------------------------------------------------------------
Display only Negative values (note: use less than symbol as I am not allowed to put the greater then symbol here
=IF($H2please use less than symbol=0,$H2,"")
(make sure to change the cell reference like for example i gave H2,but you can change it to where your value is)