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?
|