I'm trying to create a worksheet that calculates the score from a survey.
My particular question is, can Excel do conditional if/else statements?
For example, let's say there are 3 survey questions that asks about a particular effectiveness or something. 1 being the lowest, 5 being the highest:
1) Was it fun?
2) Did you learn a lot?
3) How likely are you to come back?
So I give the survey out to 10 people. Pretend 8 answered #1; 10 answered # 2; and 5 answered #3. I want a particular cell to calculate the total number of people answering the survey. So I want Excel to go through the number of people answer 1, 2, and 3 and finding which one has the highest number of people answering the survey.
So I want excel to go through 1, and see that's there's 8 people; then go onto 2 and see that's it's 10. It then sees that more answered #2 and keeps that 10 in memory. Then it goes to #3, and sees only 5 answered it, and still keeps that 10 in memory. Then at the end, tells me 10 people answered the survey. How do I do that?
My particular question is, can Excel do conditional if/else statements?
For example, let's say there are 3 survey questions that asks about a particular effectiveness or something. 1 being the lowest, 5 being the highest:
1) Was it fun?
2) Did you learn a lot?
3) How likely are you to come back?
So I give the survey out to 10 people. Pretend 8 answered #1; 10 answered # 2; and 5 answered #3. I want a particular cell to calculate the total number of people answering the survey. So I want Excel to go through the number of people answer 1, 2, and 3 and finding which one has the highest number of people answering the survey.
So I want excel to go through 1, and see that's there's 8 people; then go onto 2 and see that's it's 10. It then sees that more answered #2 and keeps that 10 in memory. Then it goes to #3, and sees only 5 answered it, and still keeps that 10 in memory. Then at the end, tells me 10 people answered the survey. How do I do that?
Facebook
Twitter