Excel Percents formatted for 1 decimal place

[Tony No Baloney]

I am using Excel 2007.

I have a column that computes a percent. The formula looks like this:
b5/26
The percents look great (ex. 96.2%). (I formatted the cell for
percents to one decimal)

I would like the cell to the right to say "We have "&b5&" instances,
or "&b5/26
so on the cell it would say "We have 25 instances, or 96.2%)

How do I do this?

 

[Bruce Bowler]

I am using Excel 2007.

I have a column that computes a percent. The formula looks like this:
b5/26
The percents look great (ex. 96.2%). (I formatted the cell for percents
to one decimal)

I would like the cell to the right to say "We have "&b5&" instances, or
"&b5/26
so on the cell it would say "We have 25 instances, or 96.2%)

How do I do this?

Check out the "concatenate" function...

Bruce

 

[Dave Peterson]

="We have " & b5 & " instances, or " & text(b5/26,"#,##0.00%")

You will need that =text() function if you want dates or times or money or ..., too.

 

[joeu2004]

I have a column that computes a percent.  The formula looks like this:
b5/26
The percents look great (ex. 96.2%).  (I formatted the cell for
percents to one decimal)

I would like the cell to the right to say "We have "&b5&" instances,
or "&b5/26

="We have " & B5 & " instances, or " & TEXT(B5/26,"0.0%")