disagree

  1. R

    IFS gone now what?

    Hi all, So I'm trying to figure out what I need since it seems that the IFS formula has been taken away. I have several questions that students need to answer, and their choice from a drop down list is in cells H3 and the list is Agree, Disagree, Not Applicable. The results will be...
  2. M

    Changing Sort Order for Chart

    I have some questionnaire results to add to a chart. The responses are: strongly disagree, disagree, neutral, agree, and strongly agree. Is it possible to have the bar graph results sort in that order?
  3. P

    Summing the number of times a value occurred, into a percentage

    Hi, I've got some data which is assigned to a raw value, eg: Strongly Disagree = 1 Disagree = 2 Neither Agree nor Disagree = 3 Agree = 4 Strongly Agree = 5 Lets say my raw data is as follows: Data point #1 : 2 Data point #2 : 3 Data point #3 : 2 Data point #4 : 1 Data point #5 : 5 For...
  4. W

    Survey Questions, If/And/Or?

    Hello, I conducted a survey on people's emotional well-being after they had received a emotional counselling service. I asked respondents 5 separate questions on how effective the counselling service was with 7 response options: - Strongly agree - Agree - Neither agree or disagree - Disagree -...
  5. T

    Set of conditions that outputs specific value between a range of cells.

    Hi, This might be a bit wordy so I apologise in advance. Basically, I have a set of data where a range of cells display either "1. Agree", "2. Agree with Recommendations" or "3. Disagree". For concreteness, let's assume that these are in A1:A5. Essentially, I would like cell A6 to display...
  6. S

    Counting the number of Agrees and Disagrees depending on what department someone belongs to

    Hi all, Was wondering if someone could help me with this. I have a list of participants all belonging to different departments and they have all answered a number of items using the ratings "Strongly agree, Agree, No opinion, Disagree, Strongly disagree". I want to be able to count the number...
  7. B

    Converting text likert scale to numbers and getting a resulting average

    I've been handed a spreadsheet with a set of rows for a group of employees, one employee per row. Along the rows are columns for ratings. Each rating is a data validation list selecting from one of 6 terms describing performance: "Strongly Agree," "Agree," "Neutral," "Disagree," "Strongly...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top