Aitziber Altuna Posted November 30, 2017 Share Posted November 30, 2017 I am finding trouble to show the next information in the databases. What I want to show is: show area if class is not Area-Exempt. Hope someone can help here. Quote Link to comment
Pat Stanford Posted November 30, 2017 Share Posted November 30, 2017 I am not certain I understand what you want to do. Do you already have a database? If so, then a formula similar to =if(C='Area-Exempt',' ',Area) should give you a column that will have the area listed for every object in the database except those that Iare in the exempt class where the value will be blank. Or do you need to create a database? In which case you would just set up your criteria to include a Class Is not 'Area-Exempt' option. This will give you a database of objects that are not in the exempt class and you can add a formula to get the area in whatever column you want. If this has not been clear enough, please ask again. 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.