Revit parameter formula if and

[esvitasheva]

Hi everyone,

I am trying to set up formula which will give me few options for total height ( I need 6 options)

I found IF AND formula the best, but it works perfect only with one condition AND

if(and([Рама 34/59], [Створка 48/33]), 92 мм, 0 мм)

I need something like this! but it doesnt workS:

total height = if(and([Рама 34/59], [Створка 48/33]), 92 мм, if (and([Рама 34/59], [Створка 50/41]), 100 мм, 0 мм, if (and([Рама 44/69], [Створка 50/41]), 110 мм, 0 мм)))

[barthbradley · Accepted solution]

Conditional statements can contain numeric values, numeric parameter names, and Yes/No parameters.

Revit Formulas for "everyday" usage (revitforum.org)

...are you receiving an inconsistent units error?

Revit - Inconsistent Units and how to neutralize them. (revitforum.org)

Try this: 

 if(and([Рама 34/59], [Створка 48/33]), 92 мм, if (and([Рама 34/59], [Створка 50/41]), 100 мм, if (and([Рама 44/69], [Створка 50/41]), 110 мм, 0 мм)))

[barthbradley]

 if(and([Рама 34/59], [Створка 48/33]), 92 мм, if (and([Рама 34/59], [Створка 50/41]), 100 мм, 0 мм, if (and([Рама 44/69], [Створка 50/41]), 110 мм, 0 мм)))

[esvitasheva]

Thank you! It works!