View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wendy Wendy is offline
external usenet poster
 
Posts: 35
Default Percentage problem

Hi

I have a formula which should be counting how many accounts and what
percentage were processed within 3 days.
Total No of accounts is 121 processed in 3 days is 97 but the percentage
figures shows 79.5081967213115%. This is too many decimal places even
though I formatted the column for 1 decimal place only. How can I make it
show the percentage figure of 79.5%
="Processed within 3 days is "&COUNTIF(D:D,"<4")&" this is "&
COUNTIF(D:D,"<4")/COUNTA(D:D)*100&"%"

Thanks
Wendy