Since my title is unclear let me explain.

I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount.

Example:

=IF([Weeks Left]="1-12","coming soon",IF([Weeks Left]="13-26","Plenty time left"))

Something along those lines...

I know that I can't use 1-12, but I would rather not use an if for 1, 2, 3, 4 etc. As the column I had in mind would basically need to have ifs for 52 weeks to 400.

Is there a statement to include if the number equals 1,2,3,4,5,6,7,8,9,10,11 or 12 that It'll display "Coming Soon" in one line?

Cheers

Since my title is unclear let me explain.

I'm currently trying to work out if I can use an IF statement to find numbers inbetween a selected amount.

Example:

=IF([Weeks Left]="1-12","coming soon",IF([Weeks Left]="13-26","Plenty time left"))

Something along those lines...

I know that I can't use 1-12, but I would rather not use an if for 1, 2, 3, 4 etc. As the column I had in mind would basically need to have ifs for 52 weeks to 400.

Is there a statement to include if the number equals 1,2,3,4,5,6,7,8,9,10,11 or 12 that It'll display "Coming Soon" in one line?

Cheers