Pull-up and pull-down resistors in schematic in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table shows pins with their signal names, resistor type (pull-up or pull-down), and resistor values used in a schematic.

Cell	Value
A1	Pin
B1	Signal
C1	Resistor Type
D1	Resistor Value (Ohms)
A2	1
B2	Input1
C2	Pull-up
D2	10000
A3	2
B3	Input2
C3	Pull-down
D3	10000
A4	3
B4	Input3
C4	Pull-up
D4	4700

Formula Trace

IF(C2="Pull-up", "Connect to VCC through resistor", IF(C2="Pull-down", "Connect to GND through resistor", "No resistor"))

Step 1: C2 = "Pull-up"

Step 2: IF(TRUE, "Connect to VCC through resistor", IF(C2="Pull-down", "Connect to GND through resistor", "No resistor"))

Cell Reference Map

   A      B          C           D
1 | Pin | Signal | Resistor Type | Resistor Value
2 |  1  | Input1 |  Pull-up     |  10000
3 |  2  | Input2 |  Pull-down   |  10000
4 |  3  | Input3 |  Pull-up     |  4700

Arrow: Formula checks C2 for resistor type

The formula references cell C2 to determine if the resistor is pull-up or pull-down.

Result

   A      B          C           D               E
1 | Pin | Signal | Resistor Type | Resistor Value | Connection
2 |  1  | Input1 |  Pull-up     |  10000       | Connect to VCC through resistor
3 |  2  | Input2 |  Pull-down   |  10000       | Connect to GND through resistor
4 |  3  | Input3 |  Pull-up     |  4700        | Connect to VCC through resistor

The result column E shows the connection type based on resistor type: pull-up connects to VCC, pull-down connects to GND.

Sheet Trace Quiz - 3 Questions

What does the formula return when C2 contains 'Pull-up'?

A Connect to VCC through resistor

B Connect to GND through resistor

C No resistor

D Error

Key Result

IF resistor type is 'Pull-up' then connect to VCC, else if 'Pull-down' connect to GND, else no resistor.