If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Percntages
Hey guys, i want to know if there is a way to do something like this
I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#2
|
|||
|
|||
Percntages
Not in the same cell
If you have the no in A1 and percentage in B then you can have =A1 & "(" & B1 & ")" in C1 -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#3
|
|||
|
|||
Percntages
Probably. But a percentage of what? What is it based on?
You can concatenate multiple functions together like so: =FunctionOne&" ("&PercentageFunction&")" The downside is that this is now a text value, so can not be used in further calculations. (unless you convert it back using some method) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#4
|
|||
|
|||
Percntages
Hi,
It would have helped to know how your numbers are derived but this may get you going along the right lines. Put 100 in A1 and then this formula in a cell =A1*0.45&" ("& TEXT(A1/100*0.45,"0.00%")&" )" Mike "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#5
|
|||
|
|||
Percntages
Let me make this more clear, sorry. there are a total of 100 sqaures and circles Circles 56 (56%) Squares 54 (54%) can i write a code behind the value, that will basically display 56/100, or 54/100 as a percentage? thanks "Mike H" wrote: Hi, It would have helped to know how your numbers are derived but this may get you going along the right lines. Put 100 in A1 and then this formula in a cell =A1*0.45&" ("& TEXT(A1/100*0.45,"0.00%")&" )" Mike "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#6
|
|||
|
|||
Percntages
Hi
How about formatting the cells as percentage? Right click on the target cells Select Format Cells Choose Percentage under Category in Number tab Scroll down to 0 using the arrow down in Decimal You can still do calculation using this and the results in the select cells will be generated as percentage automatically -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#7
|
|||
|
|||
Percntages
I still need the actual number displayed also like this 56 (56%)
"Francis" wrote: Hi How about formatting the cells as percentage? Right click on the target cells Select Format Cells Choose Percentage under Category in Number tab Scroll down to 0 using the arrow down in Decimal You can still do calculation using this and the results in the select cells will be generated as percentage automatically -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#8
|
|||
|
|||
Percntages
I suggest that you put an equal sign, = , in the cells where you need
percentage and format as I have mentioned earlier. This way, you will have original numbers display without % and another with % If you need them to be in the same cell, then try =B2&" "&"("&B2&"%"&")" which will give you 56 (56%). copy, paste special, value to the cells location and delete the cells with formula but take note that this is a text and can't be use for calculation. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: I still need the actual number displayed also like this 56 (56%) "Francis" wrote: Hi How about formatting the cells as percentage? Right click on the target cells Select Format Cells Choose Percentage under Category in Number tab Scroll down to 0 using the arrow down in Decimal You can still do calculation using this and the results in the select cells will be generated as percentage automatically -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#9
|
|||
|
|||
Percntages
Try this:
In B1: =A1&TEXT(A1/100," (0%)") "Adam" wrote: I still need the actual number displayed also like this 56 (56%) "Francis" wrote: Hi How about formatting the cells as percentage? Right click on the target cells Select Format Cells Choose Percentage under Category in Number tab Scroll down to 0 using the arrow down in Decimal You can still do calculation using this and the results in the select cells will be generated as percentage automatically -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
#10
|
|||
|
|||
Percntages
Still doesn't give OP what he asked for in the sample shown originally.
45 (40%) 45 (48%) 45 is 40% of 113 or 48% of 94 I would suggest a formula in B1 like =A1&TEXT(A1/C1," (0%)") Where C1 is a number like 113 or 94 Gord Dibben MS Excel MVP On Tue, 14 Apr 2009 14:09:01 -0700, Teethless mama wrote: Try this: In B1: =A1&TEXT(A1/100," (0%)") "Adam" wrote: I still need the actual number displayed also like this 56 (56%) "Francis" wrote: Hi How about formatting the cells as percentage? Right click on the target cells Select Format Cells Choose Percentage under Category in Number tab Scroll down to 0 using the arrow down in Decimal You can still do calculation using this and the results in the select cells will be generated as percentage automatically -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Adam" wrote: Hey guys, i want to know if there is a way to do something like this I have a columns of numbers, and i want to display a percentage behind the value in the same cell like this.. 45 (40%) 45 (48%) Is there a code ic an put behind the value that will display the percentage? Thanks, -adam |
Thread Tools | |
Display Modes | |
|
|