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

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.

×