Jump to content
Sign in to follow this  
sle7en7

show class name as something else

Recommended Posts

what am I doing wrong here?

=IF((C='ELEVATION-GLASS-30dB'), '30dB', IF((C='ELEVATION-GLASS-35dB'), '35dB', IF((C='ELEVATION-GLASS-37dB'), '37dB', IF((C='ELEVATION-GLASS-40dB'), '40dB', ''))))

I'm trying to set the class name as the last string of the whole thing but I keep getting only 40dB and -1 for all the other classes. What to do?

Edited by sle7en7

Share this post


Link to post

With if/then statements in worksheets: When in doubt, add more parentheses!

=IF((C='ELEVATION-GLASS-30dB'), ('30dB'), (IF((C='ELEVATION-GLASS-35dB'), ('35dB'), (IF((C='ELEVATION-GLASS-37dB'), ('37dB'), (IF((C='ELEVATION-GLASS-40dB'), ('40dB'), 'MISC')))))))

hth

mk

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
Sign in to follow this  

 

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.

×