Creating custom symbols in PCB Design - Formula Evaluation Walkthrough

Sample Data

This data represents a list of electronic components with their symbol names, number of pins, and pin names used for creating custom symbols in PCB design.

Cell	Value
A1	Symbol Name
B1	Pin Count
C1	Pin Names
A2	Resistor
B2	2
C2	A,B
A3	Capacitor
B3	2
C3	Positive,Negative
A4	CustomIC
B4	4
C4	VCC,GND,IN,OUT

Formula Trace

CONCATENATE(A4, " with ", B4, " pins: ", C4)

Step 1: A4

Step 2: B4

Step 3: C4

Step 4: CONCATENATE("CustomIC", " with ", "4", " pins: ", "VCC,GND,IN,OUT")

Cell Reference Map

    A       B       C
1 |Symbol Name|Pin Count|Pin Names
2 |Resistor   |2       |A,B
3 |Capacitor  |2       |Positive,Negative
4 |CustomIC   |4       |VCC,GND,IN,OUT

Formula references cells A4, B4, and C4 highlighted.

The formula uses the symbol name from A4, pin count from B4, and pin names from C4 to create a descriptive label for the custom symbol.

Result

    A       B       C                       D
1 |Symbol Name|Pin Count|Pin Names           |Description
2 |Resistor   |2       |A,B                 |
3 |Capacitor  |2       |Positive,Negative   |
4 |CustomIC   |4       |VCC,GND,IN,OUT      |CustomIC with 4 pins: VCC,GND,IN,OUT

The result in cell D4 shows the concatenated description of the custom symbol, combining its name, pin count, and pin names.

Sheet Trace Quiz - 3 Questions

Which cell contains the pin count used in the formula?

A B4

B C4

C A4

D B2

Key Result

CONCATENATE combines text strings and cell values into one descriptive string.