|
|
YAY. Thanks Julie.
"JulieD" wrote:
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
"StephanieH" wrote in message
...
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.
|