你可能感兴趣的试题
NA2<NA1=NA3 NA2=NA3=NA1 NA1=NA2>NA3 NA2=NA1<NA3
A1A3 A1A2A3 A1A3A4 A2和A1A3
A1A3 A1A2A3 A1A3A4 A2和A1A3
F={A1→A2,A1→A3} F={A1→A2} F={A1→A2} F={A1A3→A2,A1A2→A3}
A1,A2,A3=10 SET 10 TO A1,A2,A3 LOCAL 10 TO A1,3.2,A3 STORE 10 TO A1,A2,A3
NA2<NA1=NA3 NA2=NA3=NA1 NA1=NA2>NA3 NA2=NA1<NA3
=(A1+A2+A3)/3 =SUM(A1:A3)/3 =AVERAGE(A1:A3) =AVERAGE(A1:A2:A3)
A1A3 A1A2A3 A1A3A4 A2和A1A3
NA2<NA1=NA3 NA2=NA3=NA1 NA1=NA2>NA3 NA2=NA1<NA3
=A1+A2+A3/3 =SUM(A1:A3)/3 =AVERAGE(A1:A3) =AVERAGE(A1:A2:A3)
'=(A1+A2+A3)/3 '=SUM(A1:A3)/3 '=AVERAGE(A1:A3) '=AVERAGE(A1:A2:A3)
A1,A2,A3=10 SET 10 TO A1,A2,A3 LOCAL 10 TO A1,A2,A3 STORE 10 TO A1,A2,A3
如果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