Help with IFERROR addition to IF formula.

I've set up an IF statement to generate the quarter based off the month for our fiscal year. I want to add an IFERROR to the formula so suppress errors in cells that do not have a Purchase Date.

Any advice is greatly appreciated!

=IF(MONTH([Purchase Date]@row) = 1, "Q4", IF(MONTH([Purchase Date]@row) = 2, "Q1", IF(MONTH([Purchase Date]@row) = 3, "Q1", IF(MONTH([Purchase Date]@row) = 4, "Q1", IF(MONTH([Purchase Date]@row) = 5, "Q2", IF(MONTH([Purchase Date]@row) = 6, "Q2", IF(MONTH([Purchase Date]@row) = 7, "Q2", IF(MONTH([Purchase Date]@row) = 8, "Q3", IF(MONTH([Purchase Date]@row) = 9, "Q3", IF(MONTH([Purchase Date]@row) = 10, "Q3", IF(MONTH([Purchase Date]@row) = 11, "Q4", IF(MONTH([Purchase Date]@row) = 12, "Q4", ""))))))))))))

Find more posts tagged with

Accepted answers

Coen

I figured it out!

What I did instead of adding an IFERROR to the formula was to add =IF[Purchase Date]@row = "", "", to the formula. Now my formula looks like:

=IF([Purchase Date]@row = "", "", IF(MONTH([Purchase Date]@row) = 1, "Q4", IF(MONTH([Purchase Date]@row) = 2, "Q1", IF(MONTH([Purchase Date]@row) = 3, "Q1", IF(MONTH([Purchase Date]@row) = 4, "Q1", IF(MONTH([Purchase Date]@row) = 5, "Q2", IF(MONTH([Purchase Date]@row) = 6, "Q2", IF(MONTH([Purchase Date]@row) = 7, "Q2", IF(MONTH([Purchase Date]@row) = 8, "Q3", IF(MONTH([Purchase Date]@row) = 9, "Q3", IF(MONTH([Purchase Date]@row) = 10, "Q3", IF(MONTH([Purchase Date]@row) = 11, "Q4", IF(MONTH([Purchase Date]@row) = 12, "Q4", "")))))))))))))

All comments

Kaveri Vipat

Hi Coen

You can try this, I have added IFERROR in your formula.

=IFERROR(IF(MONTH([Purchase Date]@row) = 1, "Q4", IF(MONTH([Purchase Date]@row) = 2, "Q1", IF(MONTH([Purchase Date]@row) = 3, "Q1", IF(MONTH([Purchase Date]@row) = 4, "Q1", IF(MONTH([Purchase Date]@row) = 5, "Q2", IF(MONTH([Purchase Date]@row) = 6, "Q2", IF(MONTH([Purchase Date]@row) = 7, "Q2", IF(MONTH([Purchase Date]@row) = 8, "Q3", IF(MONTH([Purchase Date]@row) = 9, "Q3", IF(MONTH([Purchase Date]@row) = 10, "Q3", IF(MONTH([Purchase Date]@row) = 11, "Q4", IF(MONTH([Purchase Date]@row) = 12, "Q4", "")))))))))))),””)

I hope this works for you

Have a Good Day!

Thanks,

Coen

Thank you!

Unfortunately, I am still getting an unparseable error. :(

I appreciate the help!

Coen

I figured it out!

What I did instead of adding an IFERROR to the formula was to add =IF[Purchase Date]@row = "", "", to the formula. Now my formula looks like:

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.