你可能感兴趣的试题
Thread-0 Thread-1 Thread-0 Thread-1
Thread-1 Thread-0
A1=A2+A5,A2=A3+A4不等于0 A1=A5,A2=0 A3与A4的数值不相等 A2与A5的数值相等
MAX(A1:A5)=10 MAX(A1:A5,30)=30 MAX(A1:A5,30)=3 MAX(A1:A5,25)=25
a4+a2 a2+a2+a2 a2•a3 a2•a2•a2
MAX(A1:A5) 等于 10 MAX(A1:A5,30) 等于 30 MAX(A1:A5,30) 等于 27 MAX(A1:A5,25) 等于 25
Thread-0 Thread-1 Thread-0 Thread-1 Thread-1 Thread-0
(-2)n-1 -(-2)n-1 (-2)n -(-2)n
=IF(A5<60,不及格,及格) =IF(A5<60,"不及格","及格") =IF(A5<60,及格,不及格) =IF(A5<60,"及格","不及格")
增加A5门限1 减小A5门限1 增加A5门限2 减小A5门限2
如果A1=90、A2=人数、A3=…""、A4=54、A5=36,则公式"=Count(A1:A5)"返回5 如果A1=6.28、A2=3.74,其余单元格为空,则公式"=Counta(A1:A7)"的计算结果等于2 如果A1=90、A2=人数、A3=""、A4=54、A5=36,则公式"=Count(A1:A5)"返回3 如果A1=6.28、A2=3.74,其余单元格为空,则公式"=Counta(A1:A7)"的计算结果等于3