0
0
Solidworksbi_tool~10 mins

Fillet feature on edges in Solidworks - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This table lists edges of a 3D model with their lengths and intended fillet radius. The 'Fillet Applied' column shows if the fillet feature has been applied.

CellValue
A1Edge ID
B1Length (mm)
C1Fillet Radius (mm)
D1Fillet Applied
A2E1
B250
C25
D2Yes
A3E2
B330
C33
D3No
A4E3
B440
C44
D4Yes
Formula Trace
=IF(B2>=40, "Yes", "No")
Step 1: B2>=40
Step 2: 50>=40
Step 3: IF(TRUE, "Yes", "No")
Cell Reference Map
    A      B      C      D
1 |Edge ID|Length |Radius |Fillet
  |       |(mm)   |(mm)   |Applied
2 |  E1   |  50   |  5    | Yes 
3 |  E2   |  30   |  3    | No  
4 |  E3   |  40   |  4    | Yes 

Arrow: B2 -> D2 (Length used to decide fillet)
The formula in D2 references cell B2 to check the edge length and decide if fillet is applied.
Result
    A      B      C      D
1 |Edge ID|Length |Radius |Fillet
  |       |(mm)   |(mm)   |Applied
2 |  E1   |  50   |  5    | Yes 
3 |  E2   |  30   |  3    | No  
4 |  E3   |  40   |  4    | Yes 
The fillet is applied (Yes) to edges E1 and E3 because their lengths are 50 mm and 40 mm, which are greater than or equal to 40 mm. Edge E2 does not meet the condition.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the formula check to decide if a fillet is applied?
AIf the edge ID starts with 'E'
BIf the fillet radius is greater than 4 mm
CIf the edge length is at least 40 mm
DIf the fillet is already applied
Key Result
IF(condition, "Yes", "No") returns 'Yes' if condition is true, else 'No'.