|
|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
139 Users Online (138 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
|
Forums >> Revit Building >> Technical Support >> Improper use of Boolean Expression message with my calculated value formula
|
|
|
active
Joined: Mon, Nov 27, 2006
24 Posts
No Rating |
I'm trying to apply a formula to lumber studs. I have 2x4, 2x6, 2x10, and 2x12 and I want to be able give them a length for ordering based on what there actual cut size will be. For example I want to be able to label all 2x4's under 8' in length as "2x4x8 and all 2x4's over 8' in length as 2x4x10. I would like to be able to do this for all the different pieces of lumber I listed above. I was able to get the formula to work in excel but in Revit I get this error message "Improper Use of Boolean Expression". Here is the formula: IF(AND(Stud Type="2x4",Cut Length> ,"2x4x10","2x4x8")
|
This user is offline |
|
 | |
|
|
active
Joined: Mon, Nov 27, 2006
24 Posts
No Rating |
Formula should read: IF(AND(Stud Type="2x4",Cut Length>8,"2x4x10","2x4x8")
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 7, 2009
654 Posts
 |
You're missing a closing paren after your AND expression.
|
This user is offline |
|
|
|
Similar Threads |
|
Array formula (9.1) |
Revit Building >> Technical Support
|
Mon, Sep 24, 2007 at 7:12:47 PM
|
0
|
|
String Values in Formulas |
Revit Building >> Technical Support
|
Wed, Dec 4, 2013 at 10:38:12 PM
|
5
|
|
Bookend Room Schedule with Room Number |
Revit Building >> Technical Support
|
Mon, Apr 18, 2016 at 10:54:09 AM
|
1
|
|
OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT |
Revit Building >> Technical Support
|
Fri, Nov 21, 2008 at 11:42:14 AM
|
1
|
|
Calculated totals of formula in schedule |
Revit Structure >> Technical Support
|
Fri, Sep 11, 2020 at 7:14:07 AM
|
7
|
|
|
Site Stats
Members: | 1986861 | Objects: | 22874 | Forum Posts: | 152182 | Job Listings: | 3 |
|
Search