Multiple IF Formula

annie.vercruysse

Hi,

I am looking for a formula to return a value 1-5 in a column based on a dropdown selection in another column. the options are

Strongly Agree, Agree, Neither Agree/Disagree, Disagree & Strongly Disagree.

I would like them to return a value (5,4,3,2,1)

I have tried to use a multiple IF Function and it is not working correctly.

=IF([Arrived on Time]@row = "Strongly Agree", 5), ([Arrived on Time]@row = "Disagree", 4))

Thanks!

Nic Larsen

You just need to stop closing off your arguments, more like this:

=IF([Arrived on Time]@row = "Strongly Agree", 5, IF([Arrived on Time]@row = "Disagree", 4, and so on

KPH

I think you're almost there!

Try adding an IF to the second function like this and removing the closing parenthesis after the 5:

=IF([Arrived on Time]@row = "Strongly Agree", 5, IF([Arrived on Time]@row = "Disagree", 4))