Skip to Content
0
Former Member
Jun 30, 2009 at 06:29 PM

If statement to group days

28 Views

Hi. I am rather new at this, but I am trying to group the number of days into 3 groups. They will range from 0 to 350. AS you can see, I am working with a formula for the amount of days. I thought this would be so simple, and I appear to be wrong. What have I done?

Here is what I have:

IF {@minimum days} = "0" then "<2", else

{@minimum days} = "1" then "<2", else

{@minimum days} = "2" then "<2", else

{@minimum days} = "3" then "<10", else

{@minimum days} = "4" then "<10", else

{@minimum days} = "5" then "<10", else

{@minimum days} = "6" then"<10", else

{@minimum days} = "7" then "<10", else

{@minimum days} = "8" then "<10", else

{@minimum days} = "9" then "<10", else

{@minimum days} = "10" then "<10", else

"REASON NEEDED"

Thanks for any help you can give me.