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 мм)))
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
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 мм)))
if(and([Рама 34/59], [Створка 48/33]), 92 мм, if (and([Рама 34/59], [Створка 50/41]), 100 мм, 0 мм, if (and([Рама 44/69], [Створка 50/41]), 110 мм, 0 мм)))
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.