Nested if with five condition

[Blitz_40]

Hi! I am new to PBI and DAX. I've done a few simple If statements, but have not been able to figure this one out. I know this is probably elementary, but I have spent the about three hours trying to do a DAX formula that says this:

=IF(Table[Sum of Days]>1 and <=3,”Daily”

=IF(Table[Sum of Days]>3  and  <=18,”Weekly”

=IF(Table[Sum of Days]>18 and <=28,”Monthly”

=IF(Table[Sum of Days]>29,”Other”

Otherwise Blank

I've used a dozen examples of similar conditions that I found in other solutions that you guys have provided, but I obviously don't know what I'm doing because I can't seem to modify this to any of the examples.

Can I do five conditions? Is that what is wrong? Should I be using AND instead of OR?

Thank you for any assistance!

[Greg_Deckler · Accepted solution]

@Blitz_40 - Use a SWITCH(TRUE()...) statement, not nested IF statements. Logic is cleaner, will make things very easy.

Column =
SWITCH(TRUE(),
  [Sum of Days]>1 && [Sum of Days]<=3,”Daily”,
  [Sum of Days]>3 && [Sum of Days]<=18,”Weekly”,
  [Sum of Days]>18 && [Sum of Days]<=28,”Monthly”,
  [Sum of Days]>29,”Other”,
  BLANK()
)

[Blitz_40]

@Greg_Deckler Thank you! I will be frank and say that I am not familiar with SWITCH. 

I need to explore the difference so I can understand the application. I appreciate it!