Hi all i have a if calculation which i need to expand but I can't figure it
out

=IF(AND(D21=1,D21<=7),"week",IF(AND(D21=8,D21<=1 5),"2 wks","3 wks"))
I need to expand it if you can help would be much appriciated
1-7 Wk
8 - 15 2 wks
16 - 23 3 wks
24 - 31 1 month
32 - 89 2-3 months
90 - 179 6 months
180 + season

I hope you understand that for the numbers i need the result showing in the
cell
i.e. 1- 7 number showing in cell will answer as week
Thankyou for your assistance in advance
360 + season

Create a 2 column table like this:

1...Week
8...2 wks
16...3 wks
24...1 month
32...2-3 months
90...6 months
180...season

Assume that table is in the range A1:B7

Then:

=LOOKUP(D21,A1:B7)

--
Biff
Microsoft Excel MVP


"FredDave" wrote in message
...
Hi all i have a if calculation which i need to expand but I can't figure
it
out

=IF(AND(D21=1,D21<=7),"week",IF(AND(D21=8,D21<=1 5),"2 wks","3 wks"))
I need to expand it if you can help would be much appriciated
1-7 Wk
8 - 15 2 wks
16 - 23 3 wks
24 - 31 1 month
32 - 89 2-3 months
90 - 179 6 months
180 + season

I hope you understand that for the numbers i need the result showing in
the
cell
i.e. 1- 7 number showing in cell will answer as week
Thankyou for your assistance in advance
360 + season

=LOOKUP(D21,{1,8,16,24,32,90,180},{"wk","2 wks","3 wks","1 month","2-3
months","6 months","season"})


"FredDave" wrote:

Hi all i have a if calculation which i need to expand but I can't figure it
out

=IF(AND(D21=1,D21<=7),"week",IF(AND(D21=8,D21<=1 5),"2 wks","3 wks"))
I need to expand it if you can help would be much appriciated
1-7 Wk
8 - 15 2 wks
16 - 23 3 wks
24 - 31 1 month
32 - 89 2-3 months
90 - 179 6 months
180 + season

I hope you understand that for the numbers i need the result showing in the
cell
i.e. 1- 7 number showing in cell will answer as week
Thankyou for your assistance in advance
360 + season