• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to include parentheses in text if applicable

Kimber

Kimber

Member
I have a cell showing net change -- both numerical and percentage. When positive, it has worked seamlessly, but I have negatives and I cannot find an answer. Basically, the net change is linked to two other calculated cells and an example is +30 (+6.3%) but when the answers are -55 (-10.6%) only the right parenthesis shows -- see attached.
Thank you!
 

Attachments

  • Formula to include parentheses in text if applicable.xlsx
    12 KB · Views: 2
Please try at I11

=TEXT(I13,"+0;-0")&" ("&TEXT(I14,"+0.0%);-0.0%)")
 

Attachments

  • Formula to include parentheses in text if applicable.xlsx
    11.9 KB · Views: 5
Thank you so much! I knew that I needed to move the first parenthetical mark but I just could not see it! Appreciate your help so much.
 
You must log in or register to reply here.
Back
Top