Rectangle and polygon tools in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This data represents dimensions for rectangles and polygons. Length and Width are for rectangles. Number of Sides is for polygons. Perimeter and Area will be calculated.

Cell	Value
A1	Length
B1	Width
C1	Number of Sides
D1	Perimeter
E1	Area
A2	5
B2	3
C2	4
A3	6
B3	6
C3	6

Formula Trace

IF(C2=4, 2*(A2+B2), C2 * A2)

Step 1: C2=4

Step 2: 2*(A2+B2)

Step 3: IF(TRUE, 16, C2 * A2)

Cell Reference Map

    A     B     C     D     E
1 |Length|Width |Sides |Perim.|Area |
2 |  5   |  3   |  4   |  ?   |  ?  
3 |  6   |  6   |  6   |  ?   |  ?  

The formula uses cells A2 (Length), B2 (Width), and C2 (Number of Sides) to calculate perimeter in D2.

Result

    A     B     C     D     E
1 |Length|Width |Sides |Perim.|Area |
2 |  5   |  3   |  4   |  16  |     
3 |  6   |  6   |  6   |      |     

The perimeter for the rectangle in row 2 is calculated as 16 using the formula. Area is not calculated here.

Sheet Trace Quiz - 3 Questions

What does the formula check first?

A If the length is greater than width

B If the shape is a rectangle (4 sides)

C If the number of sides is greater than 4

D If the width is zero

Key Result

IF(Number_of_Sides=4, Perimeter_of_Rectangle=2*(Length+Width), Perimeter_of_Polygon=Number_of_Sides*Length)