Thread
:
Percentage problem
View Single Post
#
2
Posted to microsoft.public.excel.misc
Keith74
external usenet poster
Posts: 120
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
Reply With Quote
Keith74
View Public Profile
Find all posts by Keith74