컴활 함수

[한솔이]

3. =IFERROR(VLOOKUP(C14,$G$14:$H$18,2,FALSE)*D14,"판매량오류")

5.=IF(AND(E24>=70,SUM(C24:D24)>=120),"합격"," ")

2-29쪽
1.
=IF(RANK.EQ(B3,$B$3:$B$11,0)=1,"대상",IF(RANK.EQ(B3,$B$3:$B$11,0)<=3,"금상",IF(RANK.EQ(B3,$B$3:$B$11,0)<=6,"동상"," ")))

2. =DAVERAGE(E2:G11,3,H2:H3)

2-41쪽
3. =DAVERAGE(A13:C21,3,A23:A24)
5.  =choose(RANK.EQ(C28,$C$28:$C$34,0),"100%","90%","80%"," "," "," ")

2-65쪽
1. =VLOOKUP(RIGHT(A3,1),$A$10:$B$13,2,FALSE)
3. =choose(WEEKDAY(B17,2),"월요일","화요일","수요일","목요일","금요일","토요일","일요일")
5. =DAVERAGE(B27:E36,4,B27:B28)

2-87쪽
2. =IFERROR(I3*40%+J3*30%+K3*30%,"입력오류")
4. =DMAX(A11:D26,4,A11:B12)&"(최저"&DMIN(A11:D26,4,A11:B12)&")"

2-99
1번    =CHOOSE(RANK.EQ(B3,$B$3:$B$7,0),"높음","높음","중간","중간","낮음")
5번   =dsum(B22:C28,2,E22:E23)&"명"

2-111
4번  =choose(mid(F13,5,1),"외장형하드","모니터","프린터","공DVD","USB메모리")