RevitCity.com Logo

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

Welcome !

256 Users Online (91 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Nov 20, 2008 at 4:54:33 PM | OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT

#1

CAPTAIN25


active

Joined: Mon, Jul 14, 2008
8 Posts
5 Stars: 1 Votes


i'm attempting to write a formula to automatically calculate the occupant load for a particular space.  what i want the formula to do is to recognize the number in one "cell" and to respond in another "cell" according to what it reads.

in other words (see attached)

if comments = 15 then divide the area by 15if not then...if comments = 20 then divide the area by 20if not then...if comments = 100 then divide the area by 100

i've read about how to write the syntax for a conditional statement with embedded IF statements and i thought i understood it (similar to excel) but i keep getting the error that reads "improper use of boolean expressions."

this is the formula i'm using:

IF(Comments=15, Area/15, IF(Comments=20, Area/20, IF(Comments=100, Area/100,0)))

what am i doing wrong?  is what i want possible?



Attached Images

48454_OLF.jpg

This user is offline

 

Fri, Nov 21, 2008 at 5:42:14 PM | OCCUPANT LOAD FROM CALCULATED VALUE/IF STATEMENT

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 374 Votes


You may want to check out these threads ;  the last one may be the closest to your needs

http://www.revitcity.com/forums.php?action=viewthread&thread_id=6668

http://www.revitcity.com/forums.php?action=viewthread&thread_id=7562

http://www.revitcity.com/forums.php?action=viewthread&thread_id=4556

http://www.revitcity.com/forums.php?action=viewthread&thread_id=10228

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

occupant load factor

Revit Building >> Technical Support

Fri, Oct 14, 2011 at 3:31:08 PM

3

Help with If then statement [ 1 2 ]

Revit Building >> Technical Support

Tue, May 5, 2009 at 7:19:10 PM

17

Occupant Load Factor Tag

Revit Building >> Technical Support

Thu, Feb 10, 2011 at 2:34:42 PM

3

Rounding Issue in Schedules

Revit Building >> Technical Support

Mon, Jan 9, 2017 at 5:55:43 PM

1

Calculating occupant loads using room schedule

Revit Building >> Technical Support

Wed, Mar 7, 2007 at 10:45:12 AM

1

Site Stats

Members:

1708250

Objects:

22271

Forum Posts:

151789

Job Listings:

3

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.4194

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights