=IF(SUM(COUNTIF(B5:B19,{6,8,10})),MIN(IF(ISNUMBER(MATCH({6,8,10},B5:B19,)),MATCH({6,8,10},B5:B19,)))-1,"") 数组公早游式春野,按下SHIFT+CTRL+ENTER三陆森销键
excel函数if嵌套超过7层
Simone
发布于 2023-07-05 21:42:54
632 阅读
