P3下拉右拉:- =IF(OR(TEXT(RIGHT($L3+$N3),"[>4]!"&RIGHT($L3+$N3)-5)*1=P$2,TEXT(TEXT($L3-$N3,"[<0]"&$L3+5-$N3),"[>4]!"&TEXT($L3-$N3,"[<0]"&$L3+5-$N3)-5)*1=P$2),P$2,"")
复制代码 或:- =IF(OR(VLOOKUP(--RIGHT($L3+$N3),{0,0;1,1;2,2;3,3;4,4;5,0;6,1;7,2;8,3;9,4},2,)=P$2,VLOOKUP(IF($L3<$N3,$L3+5-$N3,$L3-$N3),{0,0;1,1;2,2;3,3;4,4;5,0;6,1;7,2;8,3;9,4},2,)=P$2),P$2,"")
复制代码 |