excelA1,A2,A3,出现数字5,6,7时,则A4显示OK,请问如何设置公式,谢谢!
展开全部
你的描述逻辑不确切
这问题有很多种解读
如下答案哪个是你的意思
你自己选吧
=if(and(a1=5,a2=6,a3=7),""ok,"")
=if(or(a1=5,a2=6,a3=7),""ok,"")
=if(and(or(a1=5,a1=6,a1=7),or(a2=5,a2=6,a2=7),or(a3=5,a3=6,a3=7),""ok,"")
=if(or(a1=5,a1=6,a1=7,a2=5,a2=6,a2=7,a3=5,a3=6,a3=7)""ok,"")
=if(and(iferror(find(5,a1)>0,0),iferror(find(6,a2)>0,0),iferror(find(7,a3)>0,0)),""ok,"")
=if(or(iferror(find(5,a1)>0,0),iferror(find(6,a2)>0,0),iferror(find(7,a3)>0,0)),""ok,"")
...
这问题有很多种解读
如下答案哪个是你的意思
你自己选吧
=if(and(a1=5,a2=6,a3=7),""ok,"")
=if(or(a1=5,a2=6,a3=7),""ok,"")
=if(and(or(a1=5,a1=6,a1=7),or(a2=5,a2=6,a2=7),or(a3=5,a3=6,a3=7),""ok,"")
=if(or(a1=5,a1=6,a1=7,a2=5,a2=6,a2=7,a3=5,a3=6,a3=7)""ok,"")
=if(and(iferror(find(5,a1)>0,0),iferror(find(6,a2)>0,0),iferror(find(7,a3)>0,0)),""ok,"")
=if(or(iferror(find(5,a1)>0,0),iferror(find(6,a2)>0,0),iferror(find(7,a3)>0,0)),""ok,"")
...
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询