* 최신기출문제 1회 풀기 * 계산작업 ⓛ VLOOKUP EDATE QUOTIENT 몫 (MOD) 원래 식은 할인율기준=(EDATE(F3,G3)-$J$1)/30 QUOTIENT를 활용해야 하므로, 할인율기준=QUOTIENT((EDATE(F3,G3)-$J$1),30) =VLOOKUP(할인율기준,참조영역,2,TRUE) [답]=E3*(1-VLOOKUP(QUOTIENT((EDATE(F3,G3)-$J$1),30),$L$3:$M$6,2,TRUE)) ② SUMIFS(구할범위,조건범위1,”조건1”,조건범위2,”조건2”) “=건강보조제” (O) “건강보조제” (O) A30 (O) [답] =SUMIFS($I$3:$I$26,$C$3:$C$26,$A30,$D$3:$D$26,B$29) ③ [TIP]INDEX, MATCH 나오면..