After completing a calculation it is possible that the answer will be a negative. I need some method of essentially flipping the sign and I was thinking of multiplication by -1.
The first thing that came to mind was IF THEN ELSE, but I do not know how to basically do "IF Value <0 THEN (Cell Value *-1) ELSE Leave it alone"
Is this possible or do I need to bark up another tree?
Thanks for the assist.
Bookmarks