1. Registered User
Join Date
Feb 2005
Location
Northern Ireland
Posts
24

I have a cell adding various cells and calculating an average. It is formatted as a percentage.

=SUM(B38,B79,B118,B162,B201,B240,B279,B323,B362,B4 06)/10

I want to add text after the result but when I add

&" booked so far"

to the end it removes the % sign and the number returned is formatted to many decimal places. Is there a way to do:

40% booked so far

0.403333333333333 booked so far

Join Date
Nov 2004
Location
out on a limb
Posts
13,692
format the column as text/string as you value will be a text or string

=(SUM(B38,B79,B118,B162,B201,B240,B279,B323,B362,B 4 06)/10) * 100 & "% booked so far"

3. Registered User
Join Date
Feb 2005
Location
Northern Ireland
Posts
24
Originally Posted by healdem
format the column as text/string as you value will be a text or string

=(SUM(B38,B79,B118,B162,B201,B240,B279,B323,B362,B 4 06)/10) * 100 & "% booked so far"
It then returns TRUE

4. www.gvee.co.uk
Join Date
Jan 2007
Location
UK
Posts
11,445
Assuming your value is in cell A1
Code:
`=TEXT(A1 * 100, "##00.00")&"% booked so far"`

5. Registered User
Join Date
Feb 2005
Location
Northern Ireland
Posts
24
Originally Posted by gvee
Assuming your value is in cell A1
Code:
`=TEXT(A1 * 100, "##00.00")&"% booked so far"`
Mmmh! Not getting this! Where does my original formula fit with this?

Join Date
Nov 2004
Location
out on a limb
Posts
13,692
or:-
=(B38,B79,B118,B162,B201,B240,B279,B323,B362,B406)/10 & "% booked so far"
but you will need to use a text or string format on the cell

7. Registered User
Join Date
Feb 2005
Location
Northern Ireland
Posts
24
Originally Posted by healdem
or:-
=(B38,B79,B118,B162,B201,B240,B279,B323,B362,B406)/10 & "% booked so far"
but you will need to use a text or string format on the cell
With the cell formatted as TEXT it returns the formula.

Join Date
Nov 2004
Location
out on a limb
Posts
13,692