I have a single column with some negative and mostly positive values:
How do I change the negative into a positive without changing the actual value [number].
I have tried =IF(T6>0,T6,0)
This only leaves me with a zero value
Dennis
I have a single column with some negative and mostly positive values:
How do I change the negative into a positive without changing the actual value [number].
I have tried =IF(T6>0,T6,0)
This only leaves me with a zero value
Dennis
Try the ABS function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks