모의고사 7회 문제2번에 1번인데요.
식이 왜 틀린지 모르겟네요.
=IF($D3>=200,$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-(HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)+0.01)),$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT($B3,2),$H$5:$K$5,3,FALSE)))
hlookup 의 범위가 잘 못 되었네요.
=IF($D3>=200,$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-(HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)+0.01)),$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)))
아래와 같이 변경하여 확인 해 보세요.
좋은 하루 되세요.
-
*2017-03-25 19:21:59
=IF($D3>=200,$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-(HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)+0.01)),$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT($B3,2),$H$5:$K$5,3,FALSE)))
hlookup 의 범위가 잘 못 되었네요.
=IF($D3>=200,$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-(HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)+0.01)),$D3*HLOOKUP(LEFT($B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT($B3,2),$H$3:$K$5,3,FALSE)))
아래와 같이 변경하여 확인 해 보세요.
좋은 하루 되세요.