해설에 써 있는 것과 달리
저는
=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)*1.01), D3*HLOOKUP(LEFT(B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT(B3,2), $H$3:$K$5,3,FALSE))) 이렇게 했는데 왜 틀린거죠?
=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)*1.01), D3*HLOOKUP(LEFT(B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT(B3,2), $H$3:$K$5,3,FALSE)))
=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)+1%)), D3*HLOOKUP(LEFT(B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT(B3,2), $H$3:$K$5,3,FALSE)))
빨간색으로 표시한 부분에 () 를 넣고
*1.01 이 아니라 + 1% 로 변경한 후 확인 해 보세요.
좋은 하루 되세요.
"-
*2013-07-25 01:27:08
=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)*1.01), D3*HLOOKUP(LEFT(B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT(B3,2), $H$3:$K$5,3,FALSE)))
=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)+1%)), D3*HLOOKUP(LEFT(B3,2),$H$3:$K$5,2,FALSE)*(1-HLOOKUP(LEFT(B3,2), $H$3:$K$5,3,FALSE)))
빨간색으로 표시한 부분에 () 를 넣고
*1.01 이 아니라 + 1% 로 변경한 후 확인 해 보세요.
좋은 하루 되세요.
"