Revit schedule IF statement

[Jrooker06]

I want to create a If statement that will return a value between two things.

I have 3 columns that we will call column A, column B, and column C

column 'B' will always have a default text in it like lighting and column 'C' will be blank.  I want column 'A' to always bring in Column 'B' until I place something in column 'C' then i want Column 'A' to bring in 'C'

what will this formula look like?

[L.Maas]

Same like in families. This is unfortunately not possible you can do something for types like numbers and lengths. But IF statements does not work on the text type.

Example 1

A = "Apple", B= "Banana" A, B, C of type text, C is the calculated value

C: IF(A="Apple", "Apple", "No Apple")

Will generate an error

Example 2

A = 1, B= 2  A, B, are integers  and C is of type text, C is the calculated value

C: IF(A=1, "Apple", "No Apple")

Will work

So comparing text will not work.

[Jrooker06]

Using example 2 is there a way to make A=''''(nothing) so if Cell A is blank it will return a value? or does it have to be a  calculated value still?

Example 2

A = 1, B= 2  A, B, are integers  and C is of type text, C is the calculated value

C: IF(A=1, "Apple", "No Apple")

[jdiala · Accepted solution]

Not possible, since you can't test if the parameter value is a text. See family attached and go to family types.

[Jrooker06]

So if I am reading this correctly, you are controlling the statement with a yes/no parameter. By having the box checked then it will pull in your text.

[jdiala]

Yes, that's the only way to do it.

[Jrooker06]

would the formula be the same say if the false statement was pulling in the space name. [   =if(C,Space Name,b)   ]

[jdiala]

I know where you are going. Revit formula is different with lisp. So far you can't test an expression if your test value is a text. You can only test if it's a numeric value or yes/no.

[Jrooker06]

Okay,

But do you think if i tie a yes/no to a space name in the schedule that it would pull in the space name?