Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear al!!
I have a table with positive and negative values. Do you know how I can convert negatives in positives and viceversa?
Thank you for your support.
Hi,
Load * Inline
[
Numbers
100,
-222,
111,
-22,
10,
11,
-20,
22
]
Use =Fabs(Numbers) for converting everything into positive
Use =Fabs(Numbers) *-1 for converting everything into negative.
Just simply multiply your column or expression with -1 (Column/expression *-1)
Thank you very much for your support!
Appreciate.