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?