在excel中lookup在0到99中寻找错误的怎么没用 ,b10中无论输入什么东西都是现实“有”,为什么

在excel中lookup在0到99中寻找错误的怎么没用 ,b10中无论输入什么东西都是现实“有”,为什么
这个是我做的,请看看有什么问题。。=LOOKUP(B10,{0,1,2,3,4,6,7,8,10,11,12,13,15,16,17,19,20,21,22,24,25,26,28,29,30,31,33,34,35,37,38,39,40,42,43,44,46,47,48,49,51,52,53,55,56,57,58,59,60,61,62,64,65,66,67,68,70,71,73,74,75,76,77,79,80,82,83,84,85,86,88,89,91,92,93,94,95,97,98,99,5,50,9,90,14,41,18,81,23,32,27,72,36,63,45,54,69,96,78,87},{"有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","有","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无","无"})
luo219 1年前 已收到1个回答 举报

wq5128 幼苗

共回答了17个问题采纳率:100% 举报

改下公式,=IF(OR(IF(LEN(A1)=1,A1,LEFT(A1)+RIGHT(A1))={5,9,15}),"无","有")

1年前

1
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 16 q. 0.019 s. - webmaster@yulucn.com