엑셀 :: vlookup #N/A 처리

Published by onesixx on

 =IFERROR( FORMULA(), “”) 

  • 공식에 에러가 있으면, 아무것도 표기하지 않고
  • 정상적이면,                    결과값 출력

응용

텍스트  =IFERROR( FORMULA(), ”Error Message here” )
0출력   =IFERROR( FORMULA(), 0 )

Categories: Tool-SW

onesixx

Blog Owner

Subscribe
Notify of
guest

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x