Functions

The following characters tell Revit what to do between 2 values.

Command in Revit

+

–

*

/

=

<

>

^

Sum

Sum

Subtract

Multiplication

Division

Equal

Less than

More than

Exponentiation

Declarations

The following statements tell Revit whether the formula will be a Boolean, alternative, or rounding. These are included at the beginning of the formula.

Command in Revit

IF()

AND()

OR()

NOT()

ROUND()

ROUNDDOWN()

ROUNDUP()

LOG()

Definition

Conditional declaration

Declaration to add

Declaration to have an alternative

Opposite / flase declaration

Rounding

Rounding down

Rounding up

Logarithm

Conditional formula

A formula that gives a numerical value based on the condition being true.

Formula

IF ([Condicional], [Valor si cierto] , [Valor si falso])

Example

X = IF ( A > B , Z , Y )

Conditional formula with text

A formula that gives a text value based on whether the condition is true or false.

Note: The text value as a result must be enclosed in quotation marks.

Formula

IF ([Condicional], [Valor si cierto] , [Valor si falso])

Example

X = IF ( A > B , “True” , “False” )

Nested conditional formula IF() and AND()

A formula that gives a result based on two conditionals.

Formula

IF( AND( [Condicional 1], [Condicional 2]) , [Valor si cierto] , [Valor si falso])

Example

X = IF ( AND( A > B, A > C) , “True” , “False” )

Nested conditional formula IF() and OR()

A formula that gives a result based on one of two conditions being true.

Formula

IF( AND( [Alternativa Condicional 1], [Alternativa Condicional 2]) , [Valor si alguna alternativa es cierto] , [Valor si ambas alternativas son falsas])

Example

X = IF ( OR( A > B, A > C) , “True” , “False” )

Exponential

Formula that returns the exponential of a value to the indicated power.

Formula

[Valor Numérico] ^ [Potencia Numérica]

Example

X = Y ^ E

Exponential of E

Formula that returns the exponential E of a value.

Formula

exp([Valor Numérico])

Example

X = exp(N)

Circles

Formula to calculate the value of the circumference and/or area of a circle.

Formula

Circunferencia = pi() * ([Radio] * 2)
Área = pi() * [Radio] ^ 2

Example

(Circumference) X = pi() * (Radius * 2)

(Area) X = pi() * Radius ^ 2

Square Root

Formula to calculate the square root of a numerical value.

Formula

sqrt([Valor Númerico])

Example

X = sqrt(N)

Force (Yes/No) parameters to Yes

Formula that blocks a parameter to check (Yes)

Formula

[1 < 2] , [1 = 1]

Example

X = 1 < 2 , X = 1 = 1

Force (Yes/No) parameters to No

Formula that blocks a parameter to uncheck (No)

Formula

[1 > 2] , [1 = 0]

Example

X = 1 > 2 , X = 1 = 0

Known: a + b

Formula

c = sqrt(a ^ 2 + b ^ 2)

A = atan(a / b)

B = atan(b / a)

Known: a + c

Formula

b = sqrt(c ^ 2 - a ^ 2)

A = asin(a / c)

B = acos(a / c)

Known: b + c

Formula

A = acos(b / c)

a = sqrt(c ^ 2 - b ^ 2)

B = asin(b / c)

Known: c + A

Formula

a = c * sin(A)

b = c * cos(A)

B = 90° – A

Known: c + B

Formula

a = c * cos(B)

b = c * sin(B)

A = 90° – B

Known: a + B

Formula

b = a * tan(B)

c = a / cos(B)

A = 90° – B

Known: b + A

Formula

a = b * tan(A)

c = b / cos(A)

B = 90° – A

Known: a + A

Formula

b = a / tan(A)

c = a / sin(A)

B = 90° – A

Known: b + B

Formula

a = b / tan(B)

c = b / sin(B)

A = 90° – B