Smart dimension tool in Solidworks - Cell-by-Cell Formula Trace

Sample Data

Sample dimensions of a simple mechanical part: line lengths, circle diameters, and angles.

Cell	Value
A1	Line Length
A2	50
A3	75
B1	Circle Diameter
B2	30
B3	45
C1	Angle
C2	90
C3	45

Formula Trace

MAX(A2:A3) + MIN(B2:B3) + AVERAGE(C2:C3)

Step 1: MAX(A2:A3)

Step 2: MIN(B2:B3)

Step 3: AVERAGE(C2:C3)

Step 4: 75 + 30 + 67.5

Cell Reference Map

     A      B      C
  +------+------+------+
1 | Line | Circle| Angle|
  +------+------+------+
2 |  50  |  30  |  90  |
  +------+------+------+
3 |  75  |  45  |  45  |
  +------+------+------+

The formula uses cells A2, A3 for line lengths; B2, B3 for circle diameters; and C2, C3 for angles.

Result

     A      B      C      D
  +------+------+------+-------+
1 | Line | Circle| Angle| Result|
  +------+------+------+-------+
2 |  50  |  30  |  90  |       |
  +------+------+------+-------+
3 |  75  |  45  |  45  | 172.5 |
  +------+------+------+-------+

The final result 172.5 is shown in cell D3, representing the sum of max line length, min circle diameter, and average angle.

Sheet Trace Quiz - 3 Questions

What is the maximum value found in cells A2 and A3?

A 30

B 50

C 75

D 90

Key Result

Combines MAX, MIN, and AVERAGE functions on different ranges and sums their results.