tag:blogger.com,1999:blog-4011252463639388552.post8131880456602720063..comments2024-08-04T17:35:41.219-04:00Comments on JTB World Blog: AutoCAD 2006 and formulas in fields, tables and the calculatorJTB Worldhttp://www.blogger.com/profile/02249678064305703202noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4011252463639388552.post-25821871965515435472019-11-13T13:53:22.581-05:002019-11-13T13:53:22.581-05:00To round UP a number ("A" for example) t...To round UP a number ("A" for example) to (5) you can use this formula:<br />Round((A+2)/5)*5<br /><br />and Up to (0.5) you can use:<br />Round((A+0.2)/0.5)*0.5<br /><br />Basically You can use This Formula to round Up to nearest (d):<br />Round((A+0.4d)/d)*dHejazi.Whttps://www.blogger.com/profile/18401948493510197518noreply@blogger.comtag:blogger.com,1999:blog-4011252463639388552.post-1937610679544644192010-10-19T09:05:30.133-04:002010-10-19T09:05:30.133-04:00So how would I make my pipe label round to the nea...So how would I make my pipe label round to the nearest the nearest 0.5? <br /><br />FOr example, if my pipe is 50.3m, it will read 50.5m and if it's 50.8m it will become 51.0m?Styphelushttps://www.blogger.com/profile/01346196253897542642noreply@blogger.comtag:blogger.com,1999:blog-4011252463639388552.post-20650912047736726722008-08-02T12:38:00.000-04:002008-08-02T12:38:00.000-04:00Restored commentsAnonymous said... This is neat...Restored comments<BR/><BR/>Anonymous said...<BR/><BR/> This is neat. I s there a way to round UP to the nearest value? Ie, parking spaces are based on sq ft. If I have 750 Sq Ft I need to divide that by 300 to get the required 3 parking spaces<BR/><BR/> Please respond to<BR/> skemp@eeis.net<BR/> January 17, 2006 <BR/>JTB World said...<BR/><BR/> round(750/300) should do it<BR/> January 18, 2006 <BR/>JTB World said...<BR/><BR/> round(750/300+0.5) is more correct<BR/> round(750/300+0.5) gives 3<BR/> round(725/300+0.5) also gives 3<BR/><BR/> /Jimmy<BR/> January 19, 2006 <BR/>Anonymous said...<BR/><BR/> I want to round UP to the next highest 50, how would I do that? Please respond to cmwade77@gmail.com<BR/> March 28, 2006 <BR/>JTB World said...<BR/><BR/> I'm not sure if you can correctly round UP to next 50 like the Excel function CEILING. Might be possible combining ROUND and TRUNC somehow.<BR/> March 29, 2006 <BR/>Anonymous said...<BR/><BR/> Hi,<BR/><BR/> Is it possible to use an if statement in the field expression. Such aa this; if steel is 2X2 *1.5 if 3X3 *2.0 etc. I use diff. rebar with diff. wts.<BR/><BR/> Bill<BR/> May 23, 2008 <BR/>JTB World said...<BR/><BR/> "if" statements are unfortunately not supported.<BR/> May 23, 2008 <BR/>JTB World said...<BR/><BR/> If you want to round up a positive value to nearest integer it can be done using<BR/> trunc(value+0.999999999999999)<BR/> Example:<BR/> 10 is still 10<BR/> 10.01 or 10.99 is rounded up to 11<BR/> June 18, 2008JTB Worldhttps://www.blogger.com/profile/02249678064305703202noreply@blogger.com