a if calculation help
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 |
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 |
a if calculation help
=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 |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com