Jump to content

Worksheet function changing a negative to a positive


Recommended Posts

I have a worksheet I have made. Now I have two columns one that is my x position and one that is my y position. For a number of reasons the y position origin starts above all the stuff I want the coordinates of. Meaning everything is a negative y. This is intentional. However I don't want my worksheet to report -y I just want it to report y. Everything is negative so really it doesn't matter.

Here is my line:

=ROUND(YCENTER/12)

I have tired adding a *-1 in there, but that doesn't work. What can I do to make this a positive instead of a negative?

Link to comment

I had a similar situation where I needed all the values to return a positive valuse regardless if the original value was negative or positive.

I did the following (N being the original number)

(N?) [sqaure root of N].

Basically multiplying any value by itself wether negitive or positive returns a positive value. (+ x + = +), (- x - = +).

Then I just take the sqaure root of that value and done. Hope that helps.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...