Question about if statement import from Excel

Revit
1

Hi,
This is my first post and i’m new in Dynamo.
I have a question about the math. formula. In excel i have a long formula which contains ifs and “and”. i put directly the excel formula to dynamo, if statements working but one “and” statement is not working.
how can i use “and” in dynamo;
i tried simple part of the code but it is also not working.
IF(&&(500<=height, height<=1000),1,0))

full code;
if(Height<500,(2/1000*(Width+Height))((903.14*((150+Height)/1000))/180)+((Width+Height)2/10000.01),IF(&&(500<=Height,Height<=1000),((2/1000*(Width+Height))((903.14*((150+Height)/1000))/180)+((Width+Height)2/10000.01))+(((((Height/2)+150)/1000)23.14*(90/360))Width/1000),IF(Height>1000,((2/1000(Width+Height))((903.14*((150+Height)/1000))/180)+((Width+Height)2/10000.01))+(((Height+(2150))/1000)23.14(90/360))*Width/1000)))

Thanks,
Burak.

2

the formula using CodeBlock like this

if

2 Likes
3

Thank you but, i used formula option. Is there any way to do like this?

Screenshot_1
Screenshot_1.png935×505 39.2 KB

4

This will make thing easier for you.

dynamo%20forum%20if%20condition
dynamo forum if condition.PNG1660×908 389 KB

1 Like
5

there is no need to use “IF” in your statement, in your case like this

height>=500&&height<=1000?1:1;

1 Like
6

Thank you very much, i solved the problem with separating the if statements instead of “nested if”.