Clearance rules for different nets in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table shows different nets in a PCB design and their required clearance distances in mils.

Cell	Value
A1	Net Name
B1	Clearance (mil)
A2	Power
B2	10
A3	Signal
B3	6
A4	Ground
B4	8
A5	Clock
B5	12

Formula Trace

MAX(B2:B5)

Step 1: B2:B5 values = {10, 6, 8, 12}

Step 2: MAX(10, 6, 8, 12)

Cell Reference Map

     A        B
  +-------+-------+
1 | Net   | Clear |
  +-------+-------+
2 |Power  |  10   | <--
3 |Signal |  6    | <--
4 |Ground |  8    | <--
5 |Clock  |  12   | <--
  +-------+-------+

The formula references clearance values in cells B2 through B5 to find the maximum clearance.

Result

     A        B        C
  +-------+-------+--------+
1 | Net   | Clear | Result |
  +-------+-------+--------+
2 |Power  |  10   |        |
3 |Signal |  6    |        |
4 |Ground |  8    |        |
5 |Clock  |  12   |  12    |
  +-------+-------+--------+

The result 12 in cell C5 shows the maximum clearance required among all nets.

Sheet Trace Quiz - 3 Questions

What clearance value does the formula MAX(B2:B5) return?

A 10

B 12

C 8

D 6

Key Result

MAX(range) returns the largest numeric value in the specified range.