# Search the Community

Showing results for tags 'worksheet function'.

• ### Search By Tags

Type tags separated by commas.

### Forums

• Announcements
• Announcements
• News You Need
• Job Board
• Feedback
• Wishlist - Feature and Content Requests
• Known Issues
• Wishes Granted / Issues Resolved
• Forum Feedback
• General
• Troubleshooting
• General Discussion
• Architecture
• Site Design
• Entertainment
• Vision and Previsualization
• Braceworks
• Energos
• Rendering
• Workflows
• Hardware
• Customization
• AI Visualizer
• Marionette
• Vectorscript
• Python Scripting
• SDK
• 3rd Party Services, Products and Events
• Data Tags
• Solids Modeling and 3D Printing
• Subdivision
• Solids Modeling
• 3D Printing
• Vectorworks in Action
• Archive
• Resource Sharing
• Machine Design

### Calendars

• In-Person Training - US
• In-Person Training - UK
• Coffee Breaks
• Essentials Seminars
• Webinars
• Community Groups

### Categories

• Knowledgebase
• Tech Bulletins
• Troubleshooting
• Workflows
• How To
• FAQs

### Categories

• Marionette - Objects
• Marionette - Networks
• Marionette - Nodes

• 0 Replies

• 0 Reviews

• 0 Views

Found 4 results

1. ## Worksheet if-then statement

I'm working on an energy code worksheet and having trouble working out the if-then statement function: Basically, I want the worksheet to automatically say how many credits I need based on the area of the building. The area is shown in cell C1. In cell D3 I would like a formula that says: if the value in cell C1 is less than 1500 then display 5 (if the area is less than 1500 sq ft we need 5 energy credits), if the value is between 1500 and 5000 then display 8 (we need 8 credits for a 1500 - 5000 area), if the value is greater than 5000 then display 9 (for 5000 or greater areas we need 9 credits). I started with the if((logical_test), value_if_true,value_if_false) syntax: =if((C1=<1500), 5,0) but I'm definitely getting something wrong, it just shows the formula instead of a result. Does anyone know where I'm going wrong? Thanks, Kit
2. ## How do I retrieve Hinge Qty record?

Where do I find the Hinge Qty record?
3. ## Performing math on Spreadsheet and Database cells in a worksheet

I have a worksheet for calculating roof height. Roof height is based on the weighted average of the individual roof areas relative to a geodetic height. In this worksheet, I have a database cell that picks up polygons that are linked to a record. The next column lists the areas of those polygons. I now have a nice list of the polygons, their names and their areas. In the next column I want to perform a division function where the individual areas are divided by the total area. Since the total area shows up in the column header. I can link a spreadsheet cell to this column header and the total area shows up in the spreadsheet cell. ie. same value HOWEVER, When I then try to divide the spreadsheet cell area by the database header value (to get the weighted average) the spreadsheet cell changes it value to zero and the operation fails. Is there a way to get information from a database cell and perform a math function on it without ruining the value of that cell?
4. ## Custom worksheet functions with Python - restricted to Design Series?

Been looking for some definitive info on vectorworks.net and a bit of googling too. Thought I'd just ask instead. Are custom worksheet functions that you call using the RUNSCRIPT() worksheet function excluded from Fundamentals??? Conrad
×

• KBASE
• #### MARIONETTE

×
• Create New...