ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If sign of sum is negative change to positive (https://www.excelbanter.com/excel-worksheet-functions/253144-if-sign-sum-negative-change-positive.html)

BigR

If sign of sum is negative change to positive
 
I am using a formula that may produce positive or negative results. Once it
has produced the sum the sign is immaterial. I need the result to add as a
positive.
I need something that says if the sum is less than 0 change the result to
positive. How do I do that?

Mike H

If sign of sum is negative change to positive
 
Hi,

=ABS(yoursum)

Mike

"BigR" wrote:

I am using a formula that may produce positive or negative results. Once it
has produced the sum the sign is immaterial. I need the result to add as a
positive.
I need something that says if the sum is less than 0 change the result to
positive. How do I do that?



All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com