RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Technical Support >> need help with a formula for my calculated value

Search this ThreadSearch this Thread | Page 1 of 1 |

Wed, Jan 29, 2014 at 1:14:11 PM | need help with a formula for my calculated value

#1

sippel26


active

Joined: Mon, Nov 27, 2006
24 Posts
No Rating


I have a formula that has worked in excel but does not work in revit.  I'm using a formula takes a value (length of stud) and determines if its greater or less than 4'.  In one outcome if its greater I then divide by 10' and then round that number up.  The other outcome less than 4' I just use the actual number.  The formula works if I don't plug in the ROUNDUP portion.  Take a look at my formula and see what I'm missing, thank you.

 

if(Cut Length > 4,ROUNDUP((Cut Length / 10),0), (Cut Length))


This user is offline

 

Wed, Jan 29, 2014 at 1:53:12 PM | need help with a formula for my calculated value

#2

TKennedy


active

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


It looks like you aren't using the correct format for roundup (it should be "roundup(unitless number)"). I got this to work:

if(Cut Length > 4', (roundup(Cut Length / 10')) * 1', Cut Length)

That divides Cut Length by 10' to get a unitless number, rounds that up, then multiplies it by 1' to get it back to feet.


This user is offline

 

Thu, Jan 30, 2014 at 1:03:02 PM | need help with a formula for my calculated value

#3

sippel26


active

Joined: Mon, Nov 27, 2006
24 Posts
No Rating


yeah that worked, thanks


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Calculated totals of formula in schedule

Revit Structure >> Technical Support

Fri, Sep 11, 2020 at 7:14:07 AM

7

Calculated Value

Revit Systems >> Technical Support

Mon, Dec 13, 2010 at 4:46:58 PM

3

Schedules - Calculated Value does not have "Count" in the list of fields

Revit Building >> Technical Support

Thu, Oct 17, 2013 at 8:55:44 PM

2

Calculated value

Revit Building >> Technical Support

Fri, Aug 6, 2010 at 2:17:19 PM

5

Improper use of Boolean Expression message with my calculated value formula

Revit Building >> Technical Support

Thu, Jan 30, 2014 at 3:31:03 PM

2

Site Stats

Members:

1977352

Objects:

22860

Forum Posts:

152166

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

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights