Donate SIGN UP
Home > Technology > Computers > Excel - calculating percentages using words

Excel - calculating percentages using words

Avatar Image
funkylad20 | 08:24 Tue 08th Dec 2009 | Computers
4 Answers
Does anyone know how I can calculate a percentage in excel, calculating the frequency of letters?
For example, I have a list of 20 questions, of which there can be 5 answers (A,B,C,D,E).
I need to type a formula to work out what percentage are A, what percentage are B, what percentage are C etc.
prev windows live messenger
  
next FAO Chuck 'IT God & Lord of the Cyber Wave' Fickens
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image mxyzptlk
=COUNTIF(J3:J12,"a")*100/20
Need to put the % sign in the adjacent cell and change the letter for other lines
10:13 Tue 08th Dec 2009
Avatar Image mxyzptlk
Sorry, should point out that J3:j12 was the range I used to check it out and will need to be changed too
10:14 Tue 08th Dec 2009
Avatar Image Jumbuck
There is a Percent Style button which will display the contents of a cell as a percentage, so you DON'T need to multiply it by 100 (i.e. value between 0 - 0.99 gives display of 0% - 99%) n.b. the % sign will be displayed in the cell (so no need to put anything into other cells).
11:42 Tue 08th Dec 2009
Avatar Image funkylad20
Question Author
Thank you. Very much!
08:33 Wed 09th Dec 2009

1 to 4 of 4rss feed

Do you know the answer?

Excel - calculating percentages using words

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.