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 |
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 |
Percentage problem
On Jul 30, 11:40 am, Keith74 wrote:
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 Thanks thats exactly what I needed. Wendy |
Percentage problem
="Processed within 3 days is "&COUNTIF(D:D,"<4")&" this is "&
TEXT(COUNTIF(D:D,"<4")/COUNTA(D:D)*100,"0.0") &"%" or ="Processed within 3 days is "&COUNTIF(D:D,"<4")&" this is "& TEXT(COUNTIF(D:D,"<4")/COUNTA(D:D),"0.0%") and 97/121 is 80.1653%, not 79.5082%, so it sounds as if you have another problem. Did you mean 122, rather than 121? -- David Biddulph "Wendy" wrote in message ... 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 |
Percentage problem
Try,
="Processed within 3 days is " & COUNTIF(D:D,"<4") & " this is " & TEXT(COUNTIF(D:D,"<4")/COUNTA(D:D)*100,"00.00") & "%" Mike "Wendy" wrote: 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 |
All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com