a if calculation help
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
|