Forum Discussion
Thomas610
Oct 02, 2021Copper Contributor
Removing positive and negative values in excel
Hello. I am currently dealing with an excel sheet where there is multiple vendors for which each contain innumerable positive and negative value transactions. I would like a formula/shortcut tha...
Thomas610
Oct 02, 2021Copper Contributor
Kindly direct me to a link where I can retrieve the ABS approach. If this doesn't help I'll revert
Juliano-Petrukio
Oct 02, 2021Bronze Contributor
ABS() formula converts negative numbers into positive numbers.
But, with sample data would be better to understand your doubt.
But, with sample data would be better to understand your doubt.