Jump to content
JMR

Getting an absolute value of a number in a worksheet

Recommended Posts

Hi,

 

I ran into a problem where a component list displays negative numbers for extrude lengths. How to get an absolute value?

 

I'm posting this here since the thread where I found the solution is eleven years old:

 

https://forum.vectorworks.net/index.php?/topic/23463-worksheet-function-changing-a-negative-to-a-positive/&tab=comments#comment-110335

 

Eg. for the length of an extrude, this always returns a positive (absolute) value:

 

=SQRT(LENGTH*LENGTH)

 

Brilliant.

 

 

Share this post


Link to post

Did that solution come from @michaelk? It looks like one of his math major things.

 

I probably would have used

 

=IF(Length>=0, Length, Length*-1) 

 

 

If this is something that you use a lot, it may be possible to write a Worksheet Script that would be called something like  =Runscript('WS_ABS','A2') to return the absolute value of the data in cell A2.  It is too late tonight to figure out the detail, but I think it is doable.

 

Share this post


Link to post

It was someone called CS1, apparently not active since 2013. 

 

Probably others have figured this out too.

 

Thanks Pat, that's a great idea since the ABS function is not available in the worksheet functions menu. 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×