TheSwamp
CAD Forums => CAD General => Topic started by: jnieman on September 15, 2008, 02:26:24 PM
-
Ok, I've attached a drawing containing the table I'm working with here.
We have this old archaic table that was before last night, simple lines and text, that we've used on many jobs... well "we" but not "me" because I want better tools. Now. I am making this into a table with some decent intelligence so I don't have to calculate simple things over and over as revisions occur.
Here's my problem. I want to have numbers in my "total no. 9 bars" row (and for each bar size) rounded to the nearest whole number.. but when I have another cell do a =SUM(X,Y,Z) I want the number to reflect the total of the DISPLAYED numbers AFTER rounding, not BEFORE rounding.
I can't find a way to round the number of the cell except by using "data format" and ROUND() doesn't seem to work in Autocad cells.
To put it simply, here's an example: Say I have 4 cells all at 12.5, then I have a cell adding them all together
12.5 (displays 13)
12.5 (displays 13)
12.5 (displays 13)
12.5 (displays 13)
-----------------
SUM = 50 because it adds 12.5 four times, whereas I WANT it to add 13 four times, to result in 52.
Am I clear as mud?
-
clarification: see image.
The numbers it's adding up have been rounded to whole numbers via 'data format' and apparently the SUM of those cells adds it up BEFORE rounding, and THEN rounds it.
I want the total of 898 to display, not 895.
http://www.theswamp.org/lilly_pond/JoshNieman/tableoops.PNG (link to original file if the display in the post isn't readable)
(http://www.theswamp.org/lilly_pond/JoshNieman/tableoops.PNG)
-
I'm not into Tables but seems like they should allow unrounded SUMs.
Worst case use the source to sum & not the cells.
-
I've seen MULTIPLE people in forums using the =ROUND() but... it doesn't work for me... it doesn't error out, it just acts like it's not THERE...
HELP isn't very... helpful.
-
*slams head on desk*
If you hit 'data type' and set the "Data Type" to "decimal number" and the "format" to "(none)" it'll work.
If you set it to a decimal number but any other format, it fails.
So in the end, =ROUND() works only when data type is set as I said.... apparently... I'm sure there's a reason... I don't see it yet, but I'm done worrying about it now that my table works, and is cleanly assembled, as I see it.
-
Not sure this will help but see the link here.
Like I say, I'm not into tables.
Table Stuff (http://forums.augi.com/showthread.php?p=557167#post557167)
<edit: spell check> :?
-
Not sure this will hekp but see the link here.
Like I say, I'm not into tables.
Table Stuff (http://forums.augi.com/showthread.php?p=557167#post557167)
Thanks for the help, though- despite you not being a table person :) that link is exactly how I did it in the end, but gave me a couple more tips! Thanks!
-
ACTUALLY, for anyone who sees this afterwards... I noticed it changed the data format to "whole number" after I input a forumla like: =ROUND((D14*0.668)/12)
So maybe that's where I should have been in the first place o.0