I have this formula (where value = 0.75)
=IF(Sheet1!$B11="Strongly Agree",1,IF(Sheet1!$B11="Agree",0.75,IF(Sheet1!$B11="Somewhat Agree",0.5,IF(Sheet1!$B11="Disagree",0.25,IF(Sheet1!$B11="Strongly Disagree",0)))))
I want to copy this formula to to all other cells. But when I copy the formula, B11 stays.
Want I want is to replace B11 with the another value:
Any suggestions how I can do this easily?
And is using this formula the way to go?
What I want:
User can select from 5 values. Each value is translated into a number in the formula.
First 5 questions are Courage. Next 5 Commitment and so on.
After user has filled in all questions, I will calculate totals for each row (Courage, Commitment etc.)
Then I want to visualize the values in a spider graph.
Any suggestion would be appreciated.
=IF(Sheet1!$B11="Strongly Agree",1,IF(Sheet1!$B11="Agree",0.75,IF(Sheet1!$B11="Somewhat Agree",0.5,IF(Sheet1!$B11="Disagree",0.25,IF(Sheet1!$B11="Strongly Disagree",0)))))
I want to copy this formula to to all other cells. But when I copy the formula, B11 stays.
Want I want is to replace B11 with the another value:
Any suggestions how I can do this easily?
And is using this formula the way to go?
What I want:
User can select from 5 values. Each value is translated into a number in the formula.
First 5 questions are Courage. Next 5 Commitment and so on.
After user has filled in all questions, I will calculate totals for each row (Courage, Commitment etc.)
Then I want to visualize the values in a spider graph.
Any suggestion would be appreciated.
