word string + percentage combined

[bluepenink]

Hello

I'm looking to combine a sentence or phrase and show a percentage but not really able to show the % sign.

basically im trying to show this:
27% of SE population used.

this is my formula in excel:
=CEILING(53/196,0.1)&"% of SE population used."
but that is giving me......"0.3% of SE population used.

thxs!

 

[VoG]

Try

=TEXT(CEILING(53/196,0.1),"0%")&" of SE population used."

 

[RSXchin]

try this

="%" & CEILING(53/196,0.1)&" of SE population used."

take THAT VOG!!!!

:P

 

[bluepenink]

thxs for quick response.

is it possible to show 27%. i realize "ceiling" is round it up, but i would prefer it would round to the decimal i.e. 53/196 = 0.2704....so i would like for it to say.....27%..instead of 30%

 

[lenze]

=TEXT(CEILING(53/196,0.1),"#0%")&" of SE population used."

lenze

 

[VoG]

Try

=TEXT(ROUNDDOWN(CEILING(53/196,0.01),2),"0%")&" of SE population used."

which gives 28%.

 

[bluepenink]

Try

=TEXT(ROUNDDOWN(CEILING(53/196,0.01),2),"0%")&" of SE population used."

which gives 28%.

wow very neat, incorporating the rounddown in the formula. thxs for the awesome help guys!

cheers