|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
16 Users Online (14 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 |
|
![](images/spacer.gif) |
|
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 |
|
![](images/spacer.gif) |
active
Joined: Wed, Oct 7, 2009
654 Posts
![4 Stars: 7 Votes](/images/stars_4.gif) |
You're missing a closing paren after your AND expression.
|
This user is offline |
|
![](images/spacer.gif) |
![](images/spacer.gif) |
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
|
![](images/spacer.gif) |
|
Site Stats
Members: | 2026044 | Objects: | 22991 | Forum Posts: | 152208 | Job Listings: | 3 |
|