Forums >> Revit Building >> Technical Support >> yes/no and if/then

sfountain

active

Joined: Tue, Nov 14, 2006
35 Posts
No Rating

I need some help with a formula.

I'm creating a matrix style schedule that shows a "dot" if a yes/no paremter is true. Ive got that part of it working fine.

I also need a formula to show a "dot" if a yes/no parameter is false.

in this case,  i want to show apartments as ADA in a matrix style schedule. So ive created an ADA yes/no parameter.

I want that parameter to drive other paremeters in the schedule - so if the ADA yes/no paramter is true, I want items such as ADA hardware, ADA fixtures to show a "dot" I also need the opposite to occur, i.e, if the ADA yes/no paramter is false, I want standard hardware, standard fixtures to show a "dot" I hope that makes sense.

The formula im using for the true condition is:

IF(([ADA yes/no]), GRAPHIC,"") and it works fine for showing a "dot" (GRAPHIC parameter) when the condition is true.

I thought I could just swap the true and false results to get the opposite like this:

IF(([ADA yes/no])"",GRAPHIC) but that deosnt work - no errors or anything it just doesnt show anything in the schedule if the ADA yes/no parameter is false.

I think i need to use a NOt statement maybe? however i havent had much luck at all.

I've read a few posts, blogs, help files, etc and I'm just not getting it.

**UPDATE** i gave the opposite yes/no formula another try, and it seems to be working now - i must have entered something in wrong the first five times i tried it! problem solved.

This user is offline

ScubaMan

active

Joined: Tue, Apr 1, 2008
31 Posts
No Rating

Use a "not" command.

In the formula for the yes/no function place not(Parameter Name)

This will force the yes/no function to be the opposite of whatever yes/no parameter you place in the "not" command.

ADA Unit - in the formula section fill in not(Normal Unit)

Normal Unit - This one will then be the controlling check box.

Let me know if this is not what you are looking, if I misunderstood your question or if it does not make sense. 

This user is offline