Excel函数,1,2,3,4,5,6,0,依次变为1,2,3,4,5,6,7.

2024-11-14 23:43:45
推荐回答(2个)
回答1:

向量数组替换
=LOOKUP($A1,{0,1,2,3,4,5,6},{7,1,2,3,4,5,6})

回答2:

=IF(OR(A1=1,A1=2,A1=3,A1=10),1,IF(OR(A1=4,A1=5,A1=6,A1=7,A1=8,A1=9),0,""))