Adding a text value to the end of a formula

[El Salvador]

Hi, I want to add a % symbol at the end of my formula. The formula itself is just one value divided by another and multiplied by 100

=B6/B5*100

I can concatenate this output with a "%" in a new row and then hide the previous row, but I was hoping there was a way to add the % onto the end of the formula so the output showed as n% within the same cell formula.

Is this possible?

Thanks in advance for any help, which will be gratefully received.

 

[BarryL]

as text it would be

=B6/B5*100&"%"

 

[steve the fish]

Would you not use

=B6/B5

then format to percentage? Then it remains a usable number.

 

[Rick Rothstein]

Why not make your formula this...

=B6/B5

and format the cell as "Percentage"?

 

[El Salvador]

Excellent. Thanks a lot for the inputs.