Multiple IF Formula

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!

Find more posts tagged with

Accepted answers

All comments

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))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.