Multiple IF Formula
Hi,
I am looking for a formula to return a value 15 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!
Answers

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

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))
Help Article Resources
Categories
Check out the Formula Handbook template!