Excel Percents formatted for 1 decimal place

  • Thread starter Thread starter Tony No Baloney
  • Start date Start date
T

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?
 
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?
Click to expand...

Check out the "concatenate" function...

Bruce
 
="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.
 
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
Click to expand...

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