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?

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?

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?

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?