IF/ OR

Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows:

=IF($[In Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type In]5, IF($[Out Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type Out]5, IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 + [03-OCT]$4)), "W", "°")))

I have added 4 more columns that I need to add to the in as a OR function.

In Date 2, Out Date 2, Day Type In 2, Day Type Out 2

Bit of a novice with this so any direction would be great!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jason Albrecht

Hi Nlila,

It might be helpful to take a screenshot of the sheet in question?

If I'm understanding the request, I wonder if the following will help...

=IF(OR(

$[In Date]5 = ($[In Date]$4 + [03-OCT]$4),

$[In Date]5 = ($[In Date]$2 + [03-OCT]$4),

$[In Date]5 = ($[Day Type In]$2 + [03-OCT]$4)),

$[Day Type In]5,

IF(OR(

$[Out Date]5 = ($[In Date]$4 + [03-OCT]$4),

$[Out Date]5 = ($[In Date]$2 + [03-OCT]$4)

$[Out Date]5 = ($[Day Type In]$2 + [03-OCT]$4)

$[Day Type Out]5,

IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 + [03-OCT]$4)),

"W", "°")))

NLILA

Thank you Jason. I tried that and it still being a little wonky. Here is a screenshot of the sheet.

Thank you!

Screen Shot 2021-09-15 at 8.43.45 AM.png

Jason Albrecht

Thanks @NLILA

I may need to hand off to others in the community who may be able to help.

I'm not sure of the context, which cell you're putting the formula in or how to account for errors, sorry.

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.