### Author Topic: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES  (Read 155 times)

0 Members and 1 Guest are viewing this topic.

#### qui le

• Mosquito
• Posts: 3
##### HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« on: August 25, 2017, 02:06:28 am »
I have a ploblem about fomulas in revit quantities. as a attach image, i wan fomulars thk of duct, max(with,hight)>=450 is 0.8 thk, max(with,hight)>=900 is 0.9 thk, max(with,hight)<1800 is 1.2 thk, max(with,hight)>=1800 is 1.6 thk and max(with,hight)>450 is 0.6 thk.
ples help me, thanks all.

#### John Kaul (Se7en)

• Needs a day job
• Posts: 8840
##### Re: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« Reply #1 on: August 25, 2017, 08:24:54 am »
The trick is to construct your conditions in reverse order like this:
Code: [Select]
`if(or(Width > 1799, Height > 1799), 1.6,        if(or(Width > 899, Height > 899), 0.9,                if(or(Width > 449, Height > 449), 0.8,                -469)))        `
However, please note that you will have to make this a one line formula and adjust it for the values you want. The above example is just a quickly typed template to get you started and to act as a visual aid.
“Common sense is not so common.” ~Voltaire

--> Donate to TheSwamp.org <--

#### qui le

• Mosquito
• Posts: 3
##### Re: HOW CAN USE FOMULAS IN REVIT SCHEDULE/QUANTITIES
« Reply #2 on: August 27, 2017, 09:06:08 pm »
THANKS SO MUCH,
I DID