Hi There,
I've created this nested IF statement:
=if('Form Responses 1'!C3="1: Strong disagree",1,if('Form Responses 1'!C3="2: Disagree",2,if('Form Responses 1'!C3="3: Slight disagree",3,if('Form Responses 1'!C3="4: Slight agree",4,If('Form Responses 1'!C3="5: Agree",5,if('Form Responses 1'!C3="6: Strong agree",6,0))))))
What I want to do is get the formula to read a number that i enter into a blank cell that represents the row I want the formula to read from and adjust accordingly eg; 'Form Responses 1'!C3 adjusts to 'Form Responses 1'!C6 by entering 6 into a blank cell.
Is this possible?
daleEH
I've created this nested IF statement:
=if('Form Responses 1'!C3="1: Strong disagree",1,if('Form Responses 1'!C3="2: Disagree",2,if('Form Responses 1'!C3="3: Slight disagree",3,if('Form Responses 1'!C3="4: Slight agree",4,If('Form Responses 1'!C3="5: Agree",5,if('Form Responses 1'!C3="6: Strong agree",6,0))))))
What I want to do is get the formula to read a number that i enter into a blank cell that represents the row I want the formula to read from and adjust accordingly eg; 'Form Responses 1'!C3 adjusts to 'Form Responses 1'!C6 by entering 6 into a blank cell.
Is this possible?
daleEH