# Search the Community

Showing results for tags 'table formula'.

• ### Search By Tags

Type tags separated by commas.

### Forums

• News, Announcements & FAQ
• Feedback
• AutoCAD Beginners' Area
• AutoCAD 2D Drafting, Object Properties & Interface
• AutoCAD Drawing Management & Output
• AutoCAD 3D Modelling & Rendering
• AutoCAD Vertical Products
• AutoCAD Bugs, Error Messages & Quirks
• The CUI, Hatches, Linetypes, Scripts & Macros
• AutoLISP, Visual LISP & DCL
• .NET, ObjectARX & VBA
• Application Beta Testing
• Application Archive
• Other Autodesk Products
• Autodesk 3ds Max
• Autodesk Revit
• Autodesk Inventor
• Autodesk Software General
• Other CAD Products
• SketchUp
• Rhino
• SolidWorks
• MicroStation
• Design Software
• Catch All
• Resources
• Tutorials & Tips'n'Tricks
• Blocks, Images, Models & Materials
• Community
• Introduce Yourself
• Showcase
• Work In Progress
• Jobs & Training
• Chat
• Competitions

### Categories

• Programs and Scripts
• 2D AutoCAD Blocks
• 3D AutoCAD Blocks
• Images
• Backgrounds

• 0 Replies

• 0 Reviews

• 0 Views

Found 1 result

1. ## Which Table Formula will work to achieve this result?

Hello, I have about 50 blocks and each contain manuf. nos. The Data Extraction program is utilized which links these blocks to an excel spreadsheet to extract desc. & unit. to extract this data and placed in a bill of material together with the correct quantity calculated by this template. I have approximately 10 typical manuf. nos. that exist in various blocks. For example, manuf. No. "A123" will be in block "A", "G" and "M". The total quantity of this particular manuf no. is correctly calculated and placed in the bill of material. However, these manuf. no’s. quantity needs to be further divided by a “y” amount, and in the end needs to be rounded to the nearest 1 and placed on the quantity column. Can you please let me know which Table formula will work to achieve this result? Thank you.
×
×
• Create New...