AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

New Member
Posts: 2
Registered: ‎04-23-2008
Message 1 of 5 (1,548 Views)

Roundup in table formula?

1548 Views, 4 Replies
10-28-2010 08:30 AM

Hi I have imported an Excel 2003 spreadsheet into an AutoCAD 2010 Table,
all came in fine except the following formula =ROUNDUP(((SUM(E27:E33))/24),0)

Does 2010 not support ROUNDUP ? is there another way to do this?
The formula is used to calculate the number (whole) of driver boards required to drive the number of LED's calculated by the SUM function. Each driver board can drive 24 LED's, so if i have 23 LED's I need 1 driver or if I have 25 LED's I need 2 drivers

Also is there a list or table that shows what Excel functions are or are not supported in AutoCAD? I can't seem to find one.

Any help would be greatly appreciated


*Expert Elite*
Posts: 23,642
Registered: ‎11-06-2003
Message 2 of 5 (1,546 Views)

Re: Roundup in table formula?

10-28-2010 08:55 AM in reply to: eamon.fleming

Not many Excel functions are supported in AutoCAD: Start an AutoCAD table, click inside a cell, and a toolbar with the few options you can use should magically appear. Explore it. See screenshot.

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
*Expert Elite*
Posts: 1,893
Registered: ‎09-26-2006
Message 3 of 5 (1,523 Views)

Re: Roundup in table formula?

10-28-2010 01:42 PM in reply to: eamon.fleming

If I Copyclip cells from Excel and Paste Special as AutoCAD entity (link data) then the value from Excel formula came in just fine.  But I use 2011 if that makes any difference.

Distinguished Mentor
Posts: 658
Registered: ‎06-02-2010
Message 4 of 5 (1,516 Views)

Re: Roundup in table formula?

10-28-2010 03:52 PM in reply to: eamon.fleming

Makes no difference with 2011, but you should follow as shown below:

Setup the Excel Worksheet with the required number of cells and rows, changing widths of columns and heights of rows as required.


In all cases, it is recommended to leave a blank row below the title so that there will be a noticeable space below the title and the body of the worksheet.


It may be required to change the color of text.


NOTE: if the user anticipates the possibility of adding rows and/or columns at some time in the future, the user should include any additional rows and columns for this purpose when highlighting (Item 1, below.)

Highlight the area to be used as a table in AutoCAD. NOTE: for future updating, the user must include additional rows (three to six) at the bottom of the worksheet. If this is not done, updating will stop at the last row and will not include additional rows when adding to the Excel worksheet.
Copy to the clipboard, save if desired, but Do not close the Excel worksheet.
In AutoCAD, under Edit, pick Paste Special>Paste Link
The Excel worksheet will now be listed in a dialog box. Pick OK.
The Excel worksheet will now be in the AutoCAD dwg where it can be scaled and/or edited. When the inserted Excel table in AutoCAD is double picked, the Excel worksheet will become available where it can be edited, saved, and the inserted table in the AutoCAD dwg will be appropriately updated.
Posts: 3
Registered: ‎11-14-2012
Message 5 of 5 (1,020 Views)

Re: Roundup in table formula?

01-24-2013 09:05 AM in reply to: eamon.fleming

simply add 0.5 to your formula and use round().  ie. Round(1.1+.5)=2 or Round(1.6+.5)=2

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.