早教吧 育儿知识 作业答案 考试题库 百科 知识分享

excel.if,a1=1,5,67,45,35,18,29时,a2=0,否则,a2=a1+1

题目详情
excel.if,a1=1,5,67,45,35,18,29时,a2=0,否则,a2=a1+1
▼优质解答
答案和解析
=if(or(A1={1,5,67,45,35,18,29}),0,A1+1)