| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Result of a Formula Combining Text & Numbers
Trying to create a formula that concatenates text and an calculated
percentage. =CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2))) I want the result to output: Percent Change = 1.0% not Percent Change = 0.01 How do I get the calculated percentage to show as a percent? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Result of a Formula Combining Text & Numbers
Replace what's right of the equals sign with
TEXT(ROUND(((E$28-B$28)/B$28),2),"0.00%") -- Regards, Peo Sjoblom "Brad" wrote in message ... Trying to create a formula that concatenates text and an calculated percentage. =CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2))) I want the result to output: Percent Change = 1.0% not Percent Change = 0.01 How do I get the calculated percentage to show as a percent? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Result of a Formula Combining Text & Numbers
try
="Percent Change = "&text((E$28-B$28)/B$28."0.0%") "Brad" wrote: Trying to create a formula that concatenates text and an calculated percentage. =CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2))) I want the result to output: Percent Change = 1.0% not Percent Change = 0.01 How do I get the calculated percentage to show as a percent? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Result of a Formula Combining Text & Numbers
Thanks Peo that did the trick!
"Peo Sjoblom" wrote: Replace what's right of the equals sign with TEXT(ROUND(((E$28-B$28)/B$28),2),"0.00%") -- Regards, Peo Sjoblom "Brad" wrote in message ... Trying to create a formula that concatenates text and an calculated percentage. =CONCATENATE("Percent Change"," = ",(ROUND(((E$28-B$28)/B$28),2))) I want the result to output: Percent Change = 1.0% not Percent Change = 0.01 How do I get the calculated percentage to show as a percent? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text and formula | Excel Discussion (Misc queries) | |||
| combining numbers and text | Excel Worksheet Functions | |||
| How do I convert formula result into numbers so I can sum results? | Excel Discussion (Misc queries) | |||
| combining text and numbers in a string | Excel Worksheet Functions | |||
| Combining Text and numbers from two cells | Excel Discussion (Misc queries) | |||
Linear Mode
