EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/21 17:27:56
EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式
A1=1,B1=8,9,0,1,2,3,4
A1=2,B1=9,0,1,2,3,4,5
A1=3,B1=0,1,2,3,4,5,6
A1=4,B1=1,2,3,4,5,6,7
A1=5,B1=2,3,4,5,6,7,8
A1=6,B1=3,4,5,6,7,8,9
A1=7,B1=4,5,6,7,8,9,0
A1=8,B1=5,6,7,8,9,0,1
A1=9,B1=6,7,8,9,0,1,2
A1=0,B1=7,8,9,0,1,2,3
就是这样的意思,这是全部的规则,如果B1满足这上面的数字却A1也是对应的数字的话,那么在C1显示“正确”好难.求大神解答.在线蹲等
A1=1,B1=8,9,0,1,2,3,4
A1=2,B1=9,0,1,2,3,4,5
A1=3,B1=0,1,2,3,4,5,6
A1=4,B1=1,2,3,4,5,6,7
A1=5,B1=2,3,4,5,6,7,8
A1=6,B1=3,4,5,6,7,8,9
A1=7,B1=4,5,6,7,8,9,0
A1=8,B1=5,6,7,8,9,0,1
A1=9,B1=6,7,8,9,0,1,2
A1=0,B1=7,8,9,0,1,2,3
就是这样的意思,这是全部的规则,如果B1满足这上面的数字却A1也是对应的数字的话,那么在C1显示“正确”好难.求大神解答.在线蹲等
C1单元格写入公式
=IF(OR(A1="",B1=""),"",CHOOSE(A1+1,IF(OR(B1={7,8,9,0,1,2,3}),"正确",""),IF(OR(B1={8,9,0,1,2,3,4}),"正确",""),IF(OR(B1={9,0,1,2,3,4,5}),"正确",""),IF(OR(B1={0,1,2,3,4,5,6}),"正确",""),IF(OR(B1={1,2,3,4,5,6,7}),"正确",""),IF(OR(B1={2,3,4,5,6,7,8}),"正确",""),IF(OR(B1={3,4,5,6,7,8,9}),"正确",""),IF(OR(B1={4,5,6,7,8,9,0}),"正确",""),IF(OR(B1={5,6,7,8,9,0,1}),"正确",""),IF(OR(B1={6,7,8,9,0,1,2}),"正确","")))
再简写一下
=IF(OR(A1="",B1=""),"",IF(CHOOSE(A1+1,OR(B1={7,8,9,0,1,2,3}),OR(B1={8,9,0,1,2,3,4}),OR(B1={9,0,1,2,3,4,5}),OR(B1={0,1,2,3,4,5,6}),OR(B1={1,2,3,4,5,6,7}),OR(B1={2,3,4,5,6,7,8}),OR(B1={3,4,5,6,7,8,9}),OR(B1={4,5,6,7,8,9,0}),OR(B1={5,6,7,8,9,0,1}),OR(B1={6,7,8,9,0,1,2})),"正确",""))
又想了一下,公式改成
=IF(OR(A1="",B1=""),"",IF(AND(AND(A1>=0,A1
=IF(OR(A1="",B1=""),"",CHOOSE(A1+1,IF(OR(B1={7,8,9,0,1,2,3}),"正确",""),IF(OR(B1={8,9,0,1,2,3,4}),"正确",""),IF(OR(B1={9,0,1,2,3,4,5}),"正确",""),IF(OR(B1={0,1,2,3,4,5,6}),"正确",""),IF(OR(B1={1,2,3,4,5,6,7}),"正确",""),IF(OR(B1={2,3,4,5,6,7,8}),"正确",""),IF(OR(B1={3,4,5,6,7,8,9}),"正确",""),IF(OR(B1={4,5,6,7,8,9,0}),"正确",""),IF(OR(B1={5,6,7,8,9,0,1}),"正确",""),IF(OR(B1={6,7,8,9,0,1,2}),"正确","")))
再简写一下
=IF(OR(A1="",B1=""),"",IF(CHOOSE(A1+1,OR(B1={7,8,9,0,1,2,3}),OR(B1={8,9,0,1,2,3,4}),OR(B1={9,0,1,2,3,4,5}),OR(B1={0,1,2,3,4,5,6}),OR(B1={1,2,3,4,5,6,7}),OR(B1={2,3,4,5,6,7,8}),OR(B1={3,4,5,6,7,8,9}),OR(B1={4,5,6,7,8,9,0}),OR(B1={5,6,7,8,9,0,1}),OR(B1={6,7,8,9,0,1,2})),"正确",""))
又想了一下,公式改成
=IF(OR(A1="",B1=""),"",IF(AND(AND(A1>=0,A1
EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式
在Excel中,已有一个计算公式如B1=A1^2,如何在C1到C5中显示当A1分别为1,2,3,4,5时B1的值.
求1个Excel公式:D1=A1*B1*C1,A1,B1,C1为0-9任意数
excel A1=0、3、6、9时,B1显示0,若A1=1,4,7时,B1显示1,若A1=2、5、8时,B1显示2,公式
在excel中,如果在A1单元格输入1或者3或者5或者7或者9中的任意一个数字,则在B1单元格里显示“奇“,如果不输入任
Excel表格中C1=A1+B1,在单元格C1内,怎样做到C1既是A1+B1的结果,又可以自己输入其他的数字,且该公式下
EXCEL中C1=A1+B1 我在D1中要用A1+B1的和乘以3,我该怎么输入公式,能直接取值?
excel中,如何设置当A1=1,则B1=C1;当A1=2,则B1=C2,
EXCEL中,A1为1或3,B1显示100;A1为2或4,B1显示200,A1为0或5,B1显示300.这公式如何写?
excel 中 A1等于0,则B1=c1+d1; A1等于1 则B1=(c1+d1 )*2 ;A1等于2则B1=0怎么写
excel中B1=A1*2 需要在A1未需入数字之前B1单元格内不显示0,求公式
excel中 A1输入AAA,B1显示一个公式=K1*K1*0.8,A1输入BBB,B1显示另一个公式K1*K1*0.7