Jump to content
Sign in to follow this  
Markus Barrera-Kolb

nested IF statement in Worksheets?

Recommended Posts

I've got a worksheet I'm using to report and tally interior floor areas. I'd like to have one column show the floor that each area object (polygon) is on, but I don't want the actual layer name (e.g. "Mod-Floor 1") to be displayed, but rather "Main Floor" or the like. This particular model has three floors. Is there a way I can use an IF statement to display the appropriate floor name, or is there a better way to accomplish this?

Thanks!

Cheers,

Markus

Share this post


Link to post

Yes,

You should be able to put in a formula like:

=if((L='Mod-Floor 1'|L='Mod-Floor 2'),'Main Floor',L)

=IF((((L='Design Layer-2') | (L='Design Layer-1'))), 'Main Floor', L)

The vertical bar between the two L= statements acts as a Logical OR function. You can add additional Pipes (vertical bars) to add additional layers.

I think there may be a limit on the length of the maximum function string of about 250 characters, so if you have may layers with long names they might not all fit in a single column.

Share this post


Link to post

Thanks Pat ??I appreciate it!

I wasn't sure how to get it to work using the pipes, but I took a wild stab at nesting the IFs and it seems to have worked:

=IF(L='Mod-Floor 0','Lower floor',(if(L='Mod-Floor 1','Main floor',(if(L='Mod-Floor 2','Upper Floor','--')))))

Thanks again!

Cheers,

Markus

Share this post


Link to post

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.

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.

×
×
  • Create New...