View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Keith74 Keith74 is offline
external usenet poster
 
Posts: 120
Default Percentage problem

The 1dp isn't having an effect as excel is seeing the value of the
cell as text, due to all the other info, try

="Processed within 3 days is "&COUNTIF(D:D,"<4")&" this is "&
round(COUNTIF(D:D,"<4")/COUNTA(D:D)*100,1)&"%"

hth

Keith