Bird
0
0
PCB Designbi_tool~10 mins

Component values and references in PCB Design - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table lists PCB components with their reference designators and their electrical values.

CellValue
A1Ref
B1Value
A2R1
B210k
A3R2
B34.7k
A4C1
B4100nF
A5C2
B510uF
Formula Trace
=CONCATENATE(A2, " = ", B2)
Step 1: A2
Step 2: B2
Step 3: CONCATENATE("R1", " = ", "10k")
Cell Reference Map
   A     B
1 Ref   Value
2 R1 -> 10k
3 R2    4.7k
4 C1    100nF
5 C2    10uF
The formula uses cells A2 and B2 to combine the component reference and its value.
Result
   A       B        C
1 Ref     Value    Description
2 R1      10k      R1 = 10k
3 R2      4.7k
4 C1      100nF
5 C2      10uF
The result in cell C2 shows the combined text 'R1 = 10k' describing the component reference and its value.
Sheet Trace Quiz - 3 Questions
Test your understanding
What value does cell A2 contain?
AR1
B10k
CC1
D100nF
Key Result
CONCATENATE combines component reference and value into a descriptive string.