你可能感兴趣的试题
MAX(A1:A5)=10 MAX(A1:A5,30)=30 MAX(A1:A5,30)=3 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+A3 =SUM(A1:A2) =A1+3 SUM(A1,A2)
(A1:A1) (A1,B1) (A4:A5,B4:B5) (A1,B2) (A1+B2)
(A1:A1) (A1,B1) (A4:A5,B4:B5) (A1,B2)
c1A1=c2A2; Q1=Q2; C1/C2=A1/A2; C1/C2=A2/A1。
TRUE =AND(15<A1,A1<100) FALSE AND(15<A1,A1<100)
(A1:A1) (A1,B1) (A4:A5,B4:B5) (A1,B2)
=A1+A2+A3/3 =SUM(A1:A3)/3 =AVERAGE(A1:A3) =AVERAGE(A1:A2:A3)
=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+A2+A3)/3 '=SUM(A1:A3)/3 '=AVERAGE(A1:A3) '=AVERAGE(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
=SUM(A1, B2: C3) =SUM(A1: C2) =SUM(A1, B2, C3) =SUM(A1: B2: C3)