你可能感兴趣的试题
=AVERAGE(A1: B1), =AVERAGE(3, "8") =COUNT(A1: B1), =COUNT(3, "8") =MAX(A1: B1) =MAX(3, "8") =MIN(A1: B1) =MIN(3, "8")
=AVERAGE(3REF! ) =AVERAGE(C1:F6) =AVERAGE(B1:E6) =A1/SUM(A1: D1)
=if(A1>=85,“优良”,if(A1>=60,“及格”,if(A1<60,“不及格”))) =if(A1>=85,“优良”,85>A1>=60,“及格”,A1<60,“不及格”) =if(A1>=85,“优良”),if(A1>=60,“及格”),if(A1<60,“不及格”) =if(A1>=85,“优良”,if(A1>=60,“及格”,“不及格”))
MAX(A1:A5) 等于 10 MAX(A1:A5,30) 等于 30 MAX(A1:A5,30) 等于 27 MAX(A1:A5,25) 等于 25
=if(A1>=85,“优良”,if(A1>=60,“及格”,if(A1<60,“不及格”))) =if(A1>=85,“优良”,85>A1>=60,“及格”,A1<60,“不及格”) =if(A1>=85,“优良”),if(A1>=60,“及格”),if(A1<60,“不及格”) =if(A1>=85,“优良”,if(A1>=60,“及格”,“不及格”))
如果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