View Single Post
  #1   Report Post  
StephanieH
 
Posts: n/a
Default Display Format with Text & Formula

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.