Get instant live expert help on I need help with excel convert negative to positive

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula that will take any negative value in one cell and convert it to positive 100 in another cell
Solved by X. H. in 26 mins
If B2-A2 is negative converts it to positive, if it is positive puts 0
Solved by Z. J. in 16 mins
Is there a way in Excel 2016 to have negative numbers add up as positive
Solved by Z. Y. in 25 mins
Hello. I'd like help sorting number with an equation to sort IF(A1<A2,1,0) . I have issue when the numbers are positive and negative. With negative I want the most negative, with positive I want the most positive, so I can not simply do A1<A2 as it doesn't satisfy the requirement I'm trying to achieve. Please help.
Solved by B. D. in 26 mins
we need help to sort negative positive in one plus
Solved by D. A. in 17 mins