|
2021년 1월부터 기존 파일 형식을 더 이상 사용할 수 없습니다. 기존 파일을 전환하거나 PDF를 다운로드할 수 있습니다. 자세히 알아보기

Concatenate & Text Formula - Parenthetical Text

답변함
데모 요청하기

I am attempting to add a decimal place into the parenthetical text in the comprehensive financial statement. It appears correct for anything that isn't a zero, where it just leaves the value blank (see column A below). Any suggestions on how to fix it or a new idea on how to pull in the parenthetical numbers into the text.

=CONCATENATE("Change in unrecognized pension and postretirement benefits, net of income taxes of ",TEXT(C7,"####")," - ",TEXT(F14,"$#,###.#;($#,###.#)"),"; ",TEXT(D7,"####")," - ",TEXT(G14,"$#,###.#;($#,###.#)"))

0

댓글

댓글 2개

날짜 투표수
  • Dallas Thornton
    • 편집된 시간

    Use text formatting of  "$#,###.0" instead of "$#,###.#" . The # says that if it's 0 not to show it.  See below. I think the right column is what you're looking for.

     

    0
  • Murphy Sauceman

    Thank you!

    0

댓글을 남기려면 로그인하세요.