CommandManager and toolbars in Solidworks - Cell-by-Cell Formula Trace

Sample Data

This table shows different SolidWorks features and their corresponding toolbars and CommandManager tabs.

Cell	Value
A1	Feature
B1	Toolbar
C1	CommandManager Tab
A2	Sketch
B2	Sketch Toolbar
C2	Sketch Tab
A3	Features
B3	Features Toolbar
C3	Features Tab
A4	Evaluate
B4	Evaluate Toolbar
C4	Evaluate Tab
A5	Sheet Metal
B5	Sheet Metal Toolbar
C5	Sheet Metal Tab

Formula Trace

IF(B2="Sketch Toolbar", C2, "No Tab")

Step 1: B2="Sketch Toolbar"

Step 2: IF(TRUE, C2, "No Tab")

Cell Reference Map

    A           B               C
1 | Feature  | Toolbar       | CommandManager Tab
2 | Sketch   | Sketch Toolbar| Sketch Tab
3 | Features | Features Toolbar| Features Tab
4 | Evaluate | Evaluate Toolbar| Evaluate Tab
5 | Sheet Metal | Sheet Metal Toolbar | Sheet Metal Tab

Formula references B2 and C2 cells.

The formula checks the value in B2 and returns the corresponding tab name from C2 if the toolbar matches.

Result

    A           B               C               D
1 | Feature  | Toolbar       | CommandManager Tab | Result
2 | Sketch   | Sketch Toolbar| Sketch Tab        | Sketch Tab
3 | Features | Features Toolbar| Features Tab     | 
4 | Evaluate | Evaluate Toolbar| Evaluate Tab     | 
5 | Sheet Metal | Sheet Metal Toolbar | Sheet Metal Tab | 

The formula in column D checks if the toolbar in column B is 'Sketch Toolbar' and returns the matching CommandManager tab from column C. For row 2, it returns 'Sketch Tab'.

Sheet Trace Quiz - 3 Questions

What does the formula return if B2 contains 'Sketch Toolbar'?

A Features Tab

B No Tab

C Sketch Tab

D Evaluate Tab

Key Result

IF(condition, value_if_true, value_if_false) returns one value based on a condition check.