SWITCH does not add the third value

Question

Hello all,&nbsp;I have a table of Course dates with columns Order Date, Sales Amount, etc. for purchasing other products before or after a course. I calculated a Date Difference between [Course Date] and [Order Date] in a separate column using DATEDIFF.Now I want to attribute sales after the course to that course if the sale has happened not later than 90 days after the course, otherwise, I have different conditions.I have this formula:&nbsp;AfterSale = SWITCH(TRUE(),AND([DateDiff]=0,[DateDiff]&lt;=90),"After Course Sale",AND([DateDiff]&lt;0,[DateDiff]&gt;=-90),"Before Course Sale",[DateDiff]&gt;-90,"Old Sales",[DateDiff]&gt;90,"Not Related")&nbsp;I have two issues with this formula:1. for some reason, Sales that happened between 0 and 90 days are attributed as "old Sales";2. negative values are not attributed at all, I got blank cells.&nbsp;Also, I can't include Value3. I don't know why, after Result2 in the formula I am only suggested to add Result3, but I want ti Have Value3 instead.I want the formula to have 4 conditions (4 Values and 4 related Results).&nbsp;What do I do wrong?

mattallington · Accepted Answer

This is what I see.&nbsp;the first condition says "give me all results that are zero, and at the same time are less than 90". &nbsp;This will return no result as there is no number that can be both.&nbsp;the second, third conditions have cross over. Eg -45 satisfies both 2 and 3.&nbsp;

Forum Discussion

SWITCH does not add the third value

2 Replies

Related content

Alternative to SWITCH ()?

Switch -Containsstring

Sum Switch Values

Order switching mid workflow

Using Switch