Markus Barrera-Kolb Posted January 9, 2012 Share Posted January 9, 2012 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 Quote Link to comment
Pat Stanford Posted January 9, 2012 Share Posted January 9, 2012 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. 1 Quote Link to comment
Markus Barrera-Kolb Posted January 9, 2012 Author Share Posted January 9, 2012 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 Quote Link to comment
Recommended Posts
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.