none
excel, vlookup error RRS feed

  • 질문

  • <p>excel, 2016</p><p>보시는 바와 같이</p><p></p><p>소수점 2자리의 숫자에 100을 곱하여</p><p>vlookup으로 처리했습니다.</p><p></p><p>0.14, 0.28, 0.29</p><p>3개의 값이 오류로 반환됩니다.</p><p></p><p>왜그럴까요??</p><p></p><p><a href="https://filestore.community.support.microsoft.com/api/images/6e070538-22d8-4f1b-be31-8e4266a3ee19?upload=true" ms.cid="userGeneratedHyperLink" ms.cmptyp="link" ms.index="3" ms.interactiontype="1" ms.tarloc="https://filestore.community.support.microsoft.com/api/images/6e070538-22d8-4f1b-be31-8e4266a3ee19?upload=true" ms.title="" rel="noreferrer" target="_blank"><img alt="이미지" src="https://filestore.community.support.microsoft.com/api/images/6e070538-22d8-4f1b-be31-8e4266a3ee19?upload=true" /></a></p><p></p><p>파일 링크입니다.</p><p><a href="https://drive.google.com/open?id=1CF4knEsuuDG8J0CyaKGlS6gWdI5gJ8IO" ms.cid="userGeneratedHyperLink" ms.cmptyp="link" ms.index="3" ms.interactiontype="1" ms.tarloc="https://drive.google.com/open?id=1CF4knEsuuDG8J0CyaKGlS6gWdI5gJ8IO" ms.title="https://drive.google.com/open?id=1cf4knesuudg8j0cyakgls6gwdi5gj8io" rel="noreferrer" target="_blank">https://drive.google.com/open?id=1CF4knEsuuDG8J0CyaKGlS6gWdI5gJ8IO</a></p>
    2018년 2월 27일 화요일 오후 11:16

모든 응답