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? |
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