RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Technical Support >> Min Height formula not working :(

Search this ThreadSearch this Thread | Page 1 of 1 |

Sun, May 24, 2009 at 1:00:47 AM | Min Height formula not working :(

#1

muffles


active

Joined: Fri, Apr 3, 2009
18 Posts
No Rating


I've been searching the forum and can't find anything on this, so maybe someone out there has an answer inside their head for me -

I'm kind of new to using formulas (so it could be something obvious I'm missing), although I've made bunches of basic families.  Right now I'm attempting to add a Min Height parameter to a family.  This is the formula I'm using:

 

if(or(and(Min Height<10", Min Height >100'), or(Min Height=10", Min Height=100')), Min Height, if(Min Height<100', 100', 10"Winking)

 

I get an error message saying I have a circular chain of references.  Any thoughts on how to fix this?  


This user is offline

 

Sun, May 24, 2009 at 9:22:59 AM | Min Height formula not working :(

#2

tim123


active

Joined: Tue, Apr 12, 2005
1310 Posts
4 Stars: 19 Votes


Can you explain what you trying to achieve?  It would appear that for a Min Height parameter you would just need:

if (Min Height<10", 10", Min Height)

You receive that error message if you are including the same parameter in the formula as the parameter itself, eg

Min Height = Min Height + 10, or

Min Height =if (Min Height<10, 10, Min Height) 


This user is offline

View Website

Sun, May 24, 2009 at 9:37:32 AM | Min Height formula not working :(

#3

coreed


site moderator|||
coreed Avatar

Joined: Fri, Feb 10, 2006
1874 Posts
4 Stars: 16 Votes


your formula contradicts itself. if you can state how you want this formula to function in terms of Min Height we can come up with something a lot cleaner i think.

it looks like you want Min Height set to 10" if someone enters a value less than 10" or greater than 100'. anything that equals 10" to 100' will be accepted as Min Height ? if that is the case, then this formula should work.

 If ( or( Min Height <10", Min Height > 100'), 10", Min Height)

hth



Edited on: Sun, May 24, 2009 at 9:40:31 AM

-----------------------------------

best regards,

coreed,aia

bmpArchitects,Inc.

"Revit has to be implemented, Not installed." 

Long Live Revit

This user is offline

 

Sun, May 24, 2009 at 8:48:14 PM | Min Height formula not working :(

#4

muffles


active

Joined: Fri, Apr 3, 2009
18 Posts
No Rating


Thanks guys.  This is starting to make sense.  My family is a hanging canopy, and I want it to have a minimum height of 10" below the ceiling, and a max of 100' below.  

 

Sorry for the errant smiley in my previous post.  That was not supposed to be there. 


This user is offline

 

Mon, May 25, 2009 at 7:48:49 AM | Min Height formula not working :(

#5

tim123


active

Joined: Tue, Apr 12, 2005
1310 Posts
4 Stars: 19 Votes


Try this one:

=if(Length < 10", 10", if(Length > 100', 100', Length))


This user is offline

View Website

Mon, May 25, 2009 at 9:36:21 AM | tim123

#6

coreed


site moderator|||
coreed Avatar

Joined: Fri, Feb 10, 2006
1874 Posts
4 Stars: 16 Votes


Quoting tim123 from 2009-05-25 07:48:49

"

Try this one:

=if(Length < 10", 10", if(Length > 100', 100', Length))

"

ditto

=if (Min Height < 10", 10", if (Min Height > 100', 100', Min Height))



Edited on: Mon, May 25, 2009 at 9:40:47 AM

-----------------------------------

best regards,

coreed,aia

bmpArchitects,Inc.

"Revit has to be implemented, Not installed." 

Long Live Revit

This user is offline

 

Wed, May 27, 2009 at 6:53:47 PM | Min Height formula not working :(

#7

muffles


active

Joined: Fri, Apr 3, 2009
18 Posts
No Rating


Thanks so much you guys!  It makes a lot more sense now.  I appreciate the help!

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Setting Window Head Height

Revit Building >> Technical Support

Fri, Feb 24, 2017 at 12:16:49 AM

14

Ceiling height column problem in schedules

Revit Building >> Technical Support

Fri, Dec 7, 2007 at 10:23:16 AM

0

Ceiling Height, Formula Field in Schedule???Possible or not???

Revit Building >> Technical Support

Tue, Nov 3, 2009 at 10:27:51 AM

4

Volume formula issues

Revit Building >> Technical Support

Mon, Jul 7, 2008 at 8:44:09 AM

4

label parameter formula

Revit Building >> Technical Support

Thu, Apr 26, 2012 at 12:15:03 PM

2

Site Stats

Members:

1995013

Objects:

22882

Forum Posts:

152183

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

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights