你可能感兴趣的试题
SUM(A1:A10) MIN(A1:A10) AVG(A1:A10) COUNT(A1:A10)
SUM(A1:A10) AVG(A1:A10) MIN(A1:A10) COUNT(A1:A10)
=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
COUNT(A1:A10) AVERAGE(A1:A10) MIN(A1:A10) SUM(A1:A10)
AVERAGE(A1:A10) SUM(A1:Al0) MIN(A1:A10) COUNT(A1:Al0)
SUM(A1:A10) AVG(A1:A10) MIN(A1:A10) COUNT(A1:A10)
(A1:A1) (A1,B1) (A4:A5,B4:B5) (A1,B2)
=Al+A3 =MAX(A1:A3) =SUM(A1:A3) =MIN(A1:A3)
TRUE =AND(15<A1,A1<100) FALSE AND(15<A1,A1<100)
=COUNT(A1:A6) =SUM(A1,A6) =SUM(A1:A6) =COUNT(A1,A6)
(A1:A1) (A1,B1) (A4:A5,B4:B5) (A1,B2)
=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,“及格”,“不及格”))
SUM(A1:A10) AVG(A1:A10) MIN(A1:A10) COUNT(A1:A10)
如果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