RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

255 Users Online (100 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

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Jan 30, 2014 at 7:20:05 PM | Improper use of Boolean Expression message with my calculated value formula

#1

sippel26


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>Shadey,"2x4x10","2x4x8")


This user is offline

 

Thu, Jan 30, 2014 at 8:56:23 PM | Improper use of Boolean Expression message with my calculated value formula

#2

sippel26


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

 

Thu, Jan 30, 2014 at 9:31:03 PM | Improper use of Boolean Expression message with my calculated value formula

#3

TKennedy


active

Joined: Wed, Oct 7, 2009
654 Posts
4 Stars: 7 Votes


You're missing a closing paren after your AND expression.


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Array formula (9.1)

Revit Building >> Technical Support

Tue, Sep 25, 2007 at 12:12:47 AM

0

String Values in Formulas

Revit Building >> Technical Support

Thu, Dec 5, 2013 at 4:38:12 AM

5

Bookend Room Schedule with Room Number

Revit Building >> Technical Support

Mon, Apr 18, 2016 at 3:54:09 PM

1

OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT

Revit Building >> Technical Support

Fri, Nov 21, 2008 at 5:42:14 PM

1

encountered an improper argument

Revit Building >> Technical Support

Tue, May 6, 2014 at 8:42:52 PM

1

Site Stats

Members:

1469417

Objects:

20536

Forum Posts:

150619

Job Listings:

6

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.1653

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights