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

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

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

="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

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