EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式A1=1,B1=8,9,0,1,2,3,4A1=2,B1=9,0,1,2,3,4,5A1=3,B1=0,1,2,3,4,5,6A1=4,B1=1,2,3,4,5,6,7A1=5,B1=2,3,4,5,6,7,8A1=6,B1=3,4,5,6,7,8,9A1=7,B1=4,5,6,7,8,9,0A1=8,B

来源：学生作业帮助网编辑：六六作业网时间：2024/12/23 15:07:54

EXCEL若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式A1=1,B1=8,9,0,1,2,3,4A1=2,B1=9,0,1,2,3,4,5A1=3,B

EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式A1=1,B1=8,9,0,1,2,3,4A1=2,B1=9,0,1,2,3,4,5A1=3,B1=0,1,2,3,4,5,6A1=4,B1=1,2,3,4,5,6,7A1=5,B1=2,3,4,5,6,7,8A1=6,B1=3,4,5,6,7,8,9A1=7,B1=4,5,6,7,8,9,0A1=8,B
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显示“正确”好难.求大神解答.在线蹲等

EXCEL 若A1=1,B1=8,9,0,1,2,3,4中任意一个数字,则C1显示“正确”,该如何输入公式A1=1,B1=8,9,0,1,2,3,4A1=2,B1=9,0,1,2,3,4,5A1=3,B1=0,1,2,3,4,5,6A1=4,B1=1,2,3,4,5,6,7A1=5,B1=2,3,4,5,6,7,8A1=6,B1=3,4,5,6,7,8,9A1=7,B1=4,5,6,7,8,9,0A1=8,B
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

excel A1=0、3、6、9时,B1显示0,若A1=1,4,7时,B1显示1,若A1=2、5、8时,B1显示2,公式怎么写? excel 计算如果a1-b1>0,c1=a1-b1,如果a1-b1 excel,if,a1的1,3,5,7,9尾 b1=单数,if,a1为0,2,4,6,8尾,b1=双数 EXCEL数据表格中函数怎么写?例如：A1=1时B1=1.7 A1=2时B1=1 A1=3时B1=1.2 A1=4时B1=1.5 A1=5时B1=2.7 A1=6时B1=1.9 A1=7时B1=2.2 A1=8时B1=2.1 A1=9时B1=2.4 A1=10时B1=4.2 A1=11时B1=3.1 A1=12时B1=6.7 A1=3时B1=8.7 A1=14时B1=5.7 EXCEL表格,如果A1=1、4、7则B1=1,A1=2、5、8则B1=2,A1=0、3、6、9则B1=0,该如何用函数表达? excel中有如果A1,B1中B1=0,则选A1,如果B1小于A1,则选B1的函数=IF(B1=0,A1,IF(B1 在EXCEL中如果A1=B1,C1=B1=A1.A1>B1,C1=B1-(A1-B1).A1 excel 中 A1等于0,则B1=c1+d1； A1等于1 则B1=(c1+d1 )*2 ；A1等于2则B1=0怎么写在Excel中,若A1=是,B1=1；A1=否,B1=2,怎样实现若A1=是,B1则输出1；若A1=否,B1则输出2；怎样实现?我要A1=TRUE,B1=0；A1=FALSE,B1=2；怎样实现呢?或我要A1=PROV = TRUE,B1=0；A1=PROV = FALSE,B1=2；怎样实现呢求C1的excel函数,当A1-B1为负数时C1=(A1-B1)*1.33;当A1-B1为正数时:C1=(A1-B1)*1 excel A1=0,则B1=5 ,依次轮推.A1=9,B1=4,那么B1公式怎么写? EXCEL中,如何实现：若A1=M,则B1显示1；若A1=N,则B1显示2；若A1=O,则B1显示3；若A1=P,则B1显示4--- 求excel公式当A1=1时 B1=2,当A1=3时 B1=6,当A1=8时 B1=15,当A1=15时 B1=17,求公式? excel公式：=and(b1=a1,b1, excel递增数列求和怎么表示if B1=1 B2=A1if B1=2 B2=A1+A1*A1if B1=3 B2=A1+A1*A1+A1*A1*A1if B1=4 B2=A1+A1*A1+A1*A1*A1+A1*A1*A1*A1if B1=5 B2=A1+A1*A1+A1*A1*A1+A1*A1*A1*A1+A1*A1*A1*A1*A1.以此类推这个B2公式怎么表示 EXCEL中如果：A1>B1,C1=A1-(A1-B1)*70%；如果：A1 excel函数公式设置 A1等于0则B1=B1除以B2,A1不等于0则B1=B1除以A1 求函数怎么设置 excel中,A1=B1/47,要求A1是整数且只要小数后面不是0就进1的函数是什么?excel中,A1=B1/47,要求：如果B1/47是整数,则A1=B1/47；如果B1/47是小数,则A1=B1/47+1