Formatting text within functions

[Guest]

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(H2>1,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,

 

[JE McGimpsey]

One way:

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

 

[Rick Rothstein \(MVP - VB\)]

You can use this to do what you want...

CONCATENATE(TEXT(H2/D2,"0%")," growth over 07'")

However, for a simple concatenation like that, you can eliminate the
CONCATENATE function and just use this...

TEXT(H2/D2,"0%")&" growth over 07'"

using the ampersand symbol to join the two pieces of text.

Rick

 

[Guest]

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