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

CAPTAIN25

active

Joined: Mon, Jul 14, 2008
8 Posts

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

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

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

This user is offline

occupant load factor

3

Help with If then statement [ 1 2 ]

17

Occupant Load Factor Tag

3

Rounding Issue in Schedules

1

Calculating occupant loads using room schedule

1