Hide Table of Contents

Testing Conditions to Populate Tables

You can use the logical IF to populate table entries based on a test condition.

In this example, populate a comment column of a BOM with a calculation based on the quantity column value.

  1. Add a new column to the table and label it as necessary.
  2. From the table, click a cell or column heading and for Column type, select Equation.
  3. Click the Equation tool .
  4. For Function click IF.
  5. With the cursor in the parentheses, for Columns, click QTY..

    The Columns lists includes all columns in the table. Selecting items from this list permits calculations based on column values.

  6. Enter strings and column headings to complete the calculation definition so that it reads as follows: IF('QTY.'=1;"Add "'QTY.'+2" more " 'PART NUMBER';"Standard").

    This string tests the values of the quantity column. If the quantity is zero or larger than one, the string Standard is displayed. If the quantity is one, the string Add 3 more parts is displayed.

  7. Click .

Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   Testing Conditions to Populate Tables
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: SOLIDWORKS 2014 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.