Calculated Formula

[Anonymous]

Can someone help me with how to create a calculated formula for this one?

Say I have a signage, for External and/or Internal usage. If the signage is for "External", the text would be External and if "Internal", it will be Internal obviously. That I have put the formula as (if(External, "External", "Internal). and it works perfectly fine.

But how about if the signage is both of External and Internal usage? Would like it to show as "Internal/External" but I just couldn't create the formula. Kinda suck with this.

[ToanDN]

Like this?

if(and(External,Internal),"External/Internal",if(External,"External","Internal"))

[barthbradley]

[barthbradley]

Think you need one additional @ToanDN?

@Anonymous :  This may be handy to you in the future:

https://www.revitforum.org/tutorials-tips-tricks/1046-revit-formulas-everyday-usage.html

[Anonymous]

thanks man.. but yeah, the formula provided by @barthbradley was the more accurate one (as per trying and checking). I appreciate it though. cheers!

[Anonymous]

and yes, like what I told @ToanDN , your formula works just fine (see screencast sign 2). this works tho if the instances are itemized. but if unticked, the word "External/Internal" to my so-called Calculated Parameter, wouldn't show (see screencast sign 3). As I have like say, seven (7) signages of same type - 3 of them are for External and the other 4 are for Internal. You get what I mean? Apology if I couldn't explain it as clear as much as I want to

[barthbradley]

I'm not following you. Only four conditions are possible by my count:

1st & 2nd conditions are one checked; the other not checked

3rd condition = both checked

4th condition = none checked.  

My formula evaluates all four conditions. What's left to evaluate? 

...are you maybe meaning this? 2 hot keys:  

[Anonymous]

So sorry. The one you've provided are perfectly fine.. given I have such conditions.

But what I am trying to say is that say, I have 2 signages placed - one checked External and the other is checked Internal (same like your first condition).

IF, I checked each signage with External and Internal, the "Internal/External" text would show as per your formula.

but I would not checked one signage as both external and internal. one  must be external, and one is internal; they can't be both. Take note that this two signages are of THE SAME TYPE. And unticking the itemized instances, would show no text (blank as opposed to "internal/external").. I dunno if there's a way to do that.

But then again, your formula is perfectly fine and I can definitely use. Not in this instance though.

[ToanDN]

You 1st post says "But how about if the signage is both of External and Internal usage?", and then the last post you says "I would not checked one signage as both external and internal. one must be external, and one is internal; they can't be both".

Do you see the discrepancy?

My formula is based on your 1st post and it works exactly like what you asked in that post.  It covers 3 conditions: internal, external, and internal/external.  There is no other condition if you think about it.

If your 1st post is incorrect then please clarify.

[barthbradley]

Wow, I'm still not understanding. I think I may need to drop this class and take a Performing Arts or Home Economics class instead.  Know what I mean?  Nevermind; it's a lame joke.   

Are you saying now that there is NOT 4 conditions? That there is only 3 conditions?  I'm confused.