Display Format with Text & Formula

[Guest]

I have the following formula:
="Post-Judgment: "&IF(I8=0,0,(H8/I8))&" %"
that displays as "Post-Judgment: 0.833333333333333 %"
Is it possible to force it to display as
"Post-Judgment 83%".

I've tried formatting the cell to "percentage" but that doesn't work with
the text displayed.

 

[JulieD]

Hi Stephanie

try

="Post-Judgment: "&IF(I8=0,0,TEXT((H8/I8),"##%"))

 

[Guest]

YAY. Thanks Julie.

Hi Stephanie

try

="Post-Judgment: "&IF(I8=0,0,TEXT((H8/I8),"##%"))

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway

 

[JulieD]

you're welcome
--
Cheers
JulieD

YAY. Thanks Julie.