One way:

=TEXT(D2/E2, "0%") & "growth over 07"

In article ,
jasonr17 wrote:

I am interested in a function returning a simple calculation concatenated w/
text, but would like the format of the returned caculation to be a
percentage.

ie.

=concatenate(D2/E2," growth over 07") and want it to return as

135% growth over 07

instead of
1.350323 growth over 07


here is the actual function

=IF(H2<1,"need to chase",IF(AND(H21,H2<G2)=TRUE,"08' preseason under
forecast",IF(H2<D2,"08' preseason less then
07'",IF(ISERROR(H2/D2)=TRUE,"100%",CONCATENATE(H2/D2," growth over 07'")))))

Any suggestions, Thank you,