LinkBack URL
About LinkBacks
A1 200
B1 400
C1 =sum(A1+B1)
I want C1 to be formatted as Percentage.
This shows me "600%" in C1.
However, I want to add brackets around the result in C1, like this:
C1 (600%)
How can I do this?
Put brackets around text in cell that has a formula in it
A1 200
B1 400
C1 =sum(A1+B1)
I want C1 to be formatted as Percentage.
This shows me "600%" in C1.
However, I want to add brackets around the result in C1, like this:
C1 (600%)
How can I do this?
Last edited by King Mustard; 01-17-2017 at 09:13 PM.
=A1+A2 and custom-format the cell as (General)
Entia non sunt multiplicanda sine necessitate
Sorry, I have edited my post with additional information.Originally Posted by shg
I always wonder why people wrap a calculation into the SUM function. King Mustard, why do you write
=sum(A1+B1)
when just
=A1+B1
does the same thing?
Use custom format
(0)\%
Re: Put brackets around text in cell that has a formula in it
Because I wasn't aware of that.
I used the Custom category and set Type to (0%) and it worked a treat - thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks