例子1
Orcad里part reference的值不一样,需要更新
让偶数列等于奇数列
C157 | C52 | C52 | C75 | C82 | C55 | C83 | C56 | C84 | C57 | C104 | C59 | C105 | C60 |
C52 | C52 | C75 | C82 | C55 | C83 | C56 | C84 | C57 | C104 | C59 | C105 | C60 | C114 |
C52 | C52 | C75 | C75 | C55 | C55 | C56 | C56 | C57 | C57 | C59 | C59 | C60 | C60 |
=IF(ISODD(COLUMN(Sheet1!A2)),A2,A1)
ISODD是判断奇偶
COLUMN是去列号 ROW是取行号
例子2
第三列的 奇数行等于第一列 偶数行等于第二列
=IF(ISODD(ROW(A1)),OFFSET(A$1,ROW(A1)/2,0),OFFSET(C$1,ROW(C1)/2-1,0))
ISODD是判断奇偶
OFFSET表格引用
OFFSET(A$1,ROW(A1)/2,0) 中 A$1 表示参考系为 A列第一行, ROW(A1)/2表示向下移动的行数,后面的0 表示向右移动的列数
如:
IN0_P | M28 | IN0_N | L28 | IN0_P | M28 |
IN1_P | F33 | IN1_N | E33 | IN0_N | L28 |
IN2_P | H31 | IN2_N | G31 | IN1_P | F33 |
IN3_P | E34 | IN3_N | D34 | IN1_N | E33 |
IN4_P | L7 | IN4_N | M7 | IN2_P | H31 |
IN5_P | B2 | IN5_N | C2 | IN2_N | G31 |
IN6_P | F4 | IN6_N | G4 | IN3_P | E34 |
IN7_P | C1 | IN7_N | D1 | IN3_N | D34 |
IN8_P | M30 | IN8_N | L30 | IN4_P | L7 |
IN9_P | J33 | IN9_N | H33 | IN4_N | M7 |
IN10_P | J30 | IN10_N | H30 | IN5_P | B2 |
IN11_P | H34 | IN11_N | G34 | IN5_N | C2 |
IN12_P | L5 | IN12_N | M5 | IN6_P | F4 |
IN13_P | E2 | IN13_N | F2 | IN6_N | G4 |
IN14_P | H5 | IN14_N | J5 | IN7_P | C1 |
IN15_P | F1 | IN15_N | G1 | IN7_N | D1 |
IN16_P | R28 | IN16_N | P28 | IN8_P | M30 |
IN17_P | M33 | IN17_N | L33 | IN8_N | L30 |
IN18_P | L31 | IN18_N | K31 | IN9_P | J33 |
IN19_P | L34 | IN19_N | K34 | IN9_N | H33 |
IN20_P | P7 | IN20_N | R7 | IN10_P | J30 |
IN21_P | H2 | IN21_N | J2 | IN10_N | H30 |