Display some text as a PERCENT

[Minitman]

Greetings

I have a column header that has a combination of text, dollars and
percentage. With only the text and dollars the formula looks like:

=DOLLAR(I2)& " Chart"

I need to add something like:

=DOLLAR(I2)& " Chart "&PERCENTAGE(I3)& " Tax

but PERCENTAGE is not the correct term!

Anyone know the of any way to accomplish this?

Your insights are most welcomed

-Minitman

 

[Bernie Deitrick]

Minit,

=DOLLAR(I2)& " Chart "&TEXT(I3,"0.0%")& " Tax"

Change the number of decimal places shown by changing the 0.0 part. If you
want to show a fractional value (6.75% shown as 6 3/4%), use

=DOLLAR(I2)& " Chart "&TEXT(I3,"# #/4%")& " Tax"

HTH,
Bernie
MS Excel MVP

 

[Minitman]

Hey Bernie,

That is just what I was looking for!

Thanks.

-Minitman