AutoCAD 2006 and formulas in fields, tables and the calculator
A great addition is formulas that can be used in fields, tables and the calculator. The question is what functions can be used? I've searched the documentation and found that the QuickCalc Calculator, CAL supports some standard numeric functions. Here is the list: abs,acos,asin,atan,cos,d2r,exp,exp10,ln,log,pi,r2d,round,sin,sqr,sqrt,tang,trunc as well as these operators: ^,*,/,+,-,(,).
Even though it's not specifically documented these functions and operators can be used in formulas in fields and tables.
When checking further on the formulas in fields I found that when you are editing a formula you can insert new fields. In the sample showed on the image I've grabbed the length of a line and rounded it to the nearest value that is a multiple of 5.




5 comments (add your comment):
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
Please respond to
skemp@eeis.net
round(750/300) should do it
round(750/300+0.5) is more correct
round(750/300+0.5) gives 3
round(725/300+0.5) also gives 3
/Jimmy
I want to round UP to the next highest 50, how would I do that? Please respond to cmwade77@gmail.com
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.
Post a Comment |
Subscribe to the comments feed