【函数初级201202班】练习题1（已经开帖）

286779240

请老师批改：
题目一：=COUNTIF(A4:A8,"?"&"A")
题目二：=SUMIF($A$13:$A$23,A13,$B$13:$B$23)
题目三：=IF($B27="助理工程师",C27*10%,IF(B27="工程师",C27*20%,C27*30%))

yunqingzi

第一题答案：{=SUM((LEN(A4:A8)=2)*(MID(A4:A8,2,1)="A"))}
第二题答案：=SUMIF($A$13:$A$23,A13,$B$13:$B$23)
第三题答案：=IF(B27=$B$36,C27*0.1,IF(B27=$B$28,C27*0.2,C27*0.3))

286779240

286779240 发表于 2012-7-4 17:26
请老师批改：
题目一：=COUNTIF(A4:A8,"?"&"A")
题目二：=SUMIF($A$13:$A$23,A13,$B$13:$B$23)

练习题1题目三。改成这样行不？题目三：=IF($B27="助理工程师",C27*10%,IF(B27="工程师",C27*20%,C27*30%))

萧湘无痕

习题1：
=COUNTIF(A4:A8,"?A")
习题2：
=SUMIF(A$13:B$23,A13,B$13:B$23)
=SUMIF(A$13:B$23,A14,B$13:B$23)
=SUMIF(A$13:B$23,A15,B$13:B$23)
=SUMIF(A$13:B$23,A16,B$13:B$23)
=SUMIF(A$13:B$23,A17,B$13:B$23)
=SUMIF(A$13:B$23,A18,B$13:B$23)
=SUMIF(A$13:B$23,A19,B$13:B$23)
=SUMIF(A$13:B$23,A20,B$13:B$23)
=SUMIF(A$13:B$23,A21,B$13:B$23)
=SUMIF(A$13:B$23,A22,B$13:B$23)
=SUMIF(A$13:B$23,A23,B$13:B$23)
习题3：
=IF(B27 ="助理工程师",C27*0.1,(IF(B27 ="工程师",C27*0.2,C27*0.3)))
=IF(B28 ="助理工程师",C28*0.1,(IF(B28 ="工程师",C28*0.2,C28*0.3)))
=IF(B29 ="助理工程师",C29*0.1,(IF(B29 ="工程师",C29*0.2,C29*0.3)))
=IF(B30 ="助理工程师",C30*0.1,(IF(B30 ="工程师",C30*0.2,C30*0.3)))
=IF(B31 ="助理工程师",C31*0.1,(IF(B31 ="工程师",C31*0.2,C31*0.3)))
=IF(B32 ="助理工程师",C32*0.1,(IF(B32 ="工程师",C32*0.2,C32*0.3)))
=IF(B33 ="助理工程师",C33*0.1,(IF(B33 ="工程师",C33*0.2,C33*0.3)))
=IF(B34 ="助理工程师",C34*0.1,(IF(B34 ="工程师",C34*0.2,C34*0.3)))
=IF(B35 ="助理工程师",C35*0.1,(IF(B35 ="工程师",C35*0.2,C35*0.3)))
=IF(B36 ="助理工程师",C36*0.1,(IF(B36 ="工程师",C36*0.2,C36*0.3)))

仙鹤

对于函数完全没思路啊....做得手忙脚乱的.

绿叶+++

看了,正做着呢,有些不会

878759387

回复结果   .........................