nested IF statement in Worksheets?

[Markus Barrera-Kolb]

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

[Pat Stanford]

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.

[Markus Barrera-Kolb]

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