IF/OR Quarters Formula

Hello! I am trying to come up with a formula to assign Quarters to a sheet, based on if the month is 1, 2, 3, etc. (Jan, Feb, Mar, etc.)

I am trying to use IF(OR and I get it to work until Q2, but for some reason when I add Q3 section (highlighted) it is saying syntax is wrong. It is probably something obvious that I am not getting, but I appreciate your help!

Thank you!!

It works until this point:

=IF(OR([Month Formula]@row = "1", [Month Formula]@row = "2", [Month Formula]@row = "3"), "Q1", IF(OR([Month Formula]@row = "4", [Month Formula]@row = "5", [Month Formula]@row = "6"), "Q2", "Q4"))

This does not work:

=IF(OR([Month Formula]@row = "1", [Month Formula]@row = "2", [Month Formula]@row = "3"), "Q1", IF(OR([Month Formula]@row = "4", [Month Formula]@row = "5", [Month Formula]@row = "6"), "Q2", IF(OR([Month Formula]@row="7",[Month Formula]@row="8",[Month Formula]@row="9"[Month Formula]@row="10"),"Q3","Q4"))))

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

@SofiRuiz

Looks like you're missing a comma right here, between "9" and [Month Formula]

Also, FYI - October should go in Q4 😉

TVang

Try...

=IF(OR([Month Formula]@row = "1", [Month Formula]@row = "2", [Month Formula]@row = "3"), "Q1", IF(OR([Month Formula]@row = "4", [Month Formula]@row = "5", [Month Formula]@row = "6"), "Q2" , IF(OR([Month Formula]@row="7",[Month Formula]@row="8",[Month Formula]@row="9",[Month Formula]@row="10"),"Q3","Q4")))

Your formula:

Had an extra closing parenthesis.
Had a missing comma between [Month Formula]@row="9" and [Month Formula]@row="10".

All comments

Jeff Reisman

@SofiRuiz

Looks like you're missing a comma right here, between "9" and [Month Formula]

Also, FYI - October should go in Q4 😉

TVang

Try...

Your formula:

Had an extra closing parenthesis.
Had a missing comma between [Month Formula]@row="9" and [Month Formula]@row="10".

SofiRuiz

Thank you both!

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.