IF Statement for Negative and Positive Numbers

Hi all,

I’m wanting to add a value to a number in a list if it’s is a negative and minus a value to a number in the same list if it’s a positive. I know this should be easy but for some reason I’m struggling, any help will be appreciated.

You can use this method

3 Likes

Thanks Samuel, I knew it would a simple and elegant solution.

1 Like