Formula Question

This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is.

=OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row - 1,{Min_Skill_LTT}),"True", "False"),(IF(INDEX(MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row),"Step Down", "False")))

The objective is for the formula to Match Job Title and current skill to the Job title and Minimum skill required, look and see if it is exactly what it is supposed to be, if it is true - then true, false then false, if it is not exact I want it to verify if the numbers are only off by one and if yes return Step Down, if not then false. Any help that can be provided would be great!

Find more posts tagged with

Sheets

Support

Solution Center

Project Management

Cell linking

Accepted answers

Mark.poole

@ashly.summers

The placement of your OR statement is part of the issue. Or and And statements can only be used inside of another function. Instead try a Nested IF statement for what your trying to achieve

=IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = [LTT Matrix Use]@row, "True", IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row -1), "Step Down", "False"))

All comments

Mark.poole

@ashly.summers

The placement of your OR statement is part of the issue. Or and And statements can only be used inside of another function. Instead try a Nested IF statement for what your trying to achieve

ashly.summers

Thank you so much that worked! It was driving me crazy :)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.