IF formula: IF x in column A then enter this in this column B

Hello All,

Need some assistance with an IF formula. I want to create a formula where each month in a row is accounted for and assigned a Quarter. Q1 ( January, Feb, March), Q2 (April, May, June) Q3 (July, August, Sept) Q4 (October, Nove, Dec). Below is a part of a formula that I have come up with - let me know your thoughts:

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

You could try something like this: =IF(OR(Timeframe@row = "January", Timeframe@row = "February", Timeframe@row = "March"), "Q1", IF(OR(Timeframe@row = "April", Timeframe@row = "May", Timeframe@row = "June"), "Q2", IF(OR(Timeframe@row = "July", Timeframe@row = "August", Timeframe@row = "September"), "Q3", IF(OR(Timeframe@row = "October", Timeframe@row = "November", Timeframe@row = "December"), "Q4"))))

ssuser01

@Adam Murphy Thank you!

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.