View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Calculating percentage of non-numeric values.

all of them together equals 100 percent.
Yes's divided by Yes's plus No's times 100 is the percent Yes's. Same
way with percent No's, or subtract Yes percent from 100 to get No percent.


pharmer8 wrote:

How to I calculate percentage of Yes vs No from a sample of surveys I
collected.