I want to check a cell for one of five responses from a deeop down list. The
if works fine for up to four but the fifth is not allowed. Below is the
formula that works. belo0w that is the fifth condition I want to check for.
Any suggestions?
Thanks

=IF(Survey!E8:E8="Agree","1",IF(Survey!E8:E8="Some what
Agree","2",IF(Survey!E8:E8="Somewhat
Disagree","3",IF(Survey!E8:E8="Disagree","4"))))


IF(Survey!E8:E8="Not Aplicable","0")