EXCEL多个条件判断最后返回一个值怎么搞?如：A列是一长列数,我要在C1中输入：当A1=1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46时（只要A1等于其中一个数）,返回值为我我我,否则为空.不要辅助列,也不要A1=1,A1=2,A1=7.A1=46...#$!.这样的体力活!如果能A1={1,2,7,8,12,13,18,19,23,24,29,
网友回答
管家,老爷先来个笨办法
=if(or(A1={1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46}),老爷我,)