display value as % in concantenated cell

[Smudge]

Hi,

I'm using the REPT function to create in cell graphing which I found @
http://blogs.ittoolbox.com/bi/juiceanalytics/archives/more-on-excel-incell-graphing-11035

My problem is that when I try to add a data label by concatenating the cell
value I don't get the percentage.

Is there a way of specifying that you want the percentage format dispayed as
a label in the graphing cell? or would it be best to calculate % in number
formatted cell?

This is the formula I'm using =IF($N14<0,N14&" "&REPT("|",-$N14*100),"")

Many thanks

 

[Gary''s Student]

Here is a general method; if A1 contains:

the percentage is

and B1 contains
5%

then
=A1 & B1
displays
the percentage is 0.05

but
=A1 & TEXT(B1,"0%")
displays
the percentage is 5%

Using the TEXT() function allows you to capture the proper formats

 

[Roger Govier]

Hi

Try
=IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"")

 

[Smudge]

Thank you Gary
--
Smudge

Here is a general method; if A1 contains:

the percentage is

and B1 contains
5%

then
=A1 & B1
displays
the percentage is 0.05

but
=A1 & TEXT(B1,"0%")
displays
the percentage is 5%

Using the TEXT() function allows you to capture the proper formats

 

[Smudge]

Thank you Roger
--
Smudge

Hi

Try
=IF($N14<0,TEXT(-N14/100,"0.0%")&" "&REPT("|",-$N14*100),"")