Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i want to string @ if together to turn week number to month. so 1 to 4 = "JAN" .. 5 to 9 = "FEB" .. having trouble connecting the @ if together
Solved by T. B. in 32 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/07/2018 - 05:07
Welcome to excelchat.
Excelchat Expert 06/07/2018 - 05:07
My understanding is that you want to convert week numbers to month, is that correct? Please correct me if I'm wrong.
User 06/07/2018 - 05:08
to a text for the month 1-4 in column would be "jan" ... 5-9 would be "feb" and so on
Excelchat Expert 06/07/2018 - 05:08
Can you please show me what you said on the preview spreadsheet?
User 06/07/2018 - 05:10
I can do the one month ... but having trouble adding in more If functions
Excelchat Expert 06/07/2018 - 05:11
Just like that?
User 06/07/2018 - 05:11
yes .. and I have weeks up to 52 so need the @ if to have 12 conditions
Excelchat Expert 06/07/2018 - 05:12
I'm finding it hard to understand what do you mean by "@", but I do understand that you need to get the months name from a given week number.
User 06/07/2018 - 05:13
=IF(L2<5,"JAN")+or IF(L2>=5, "feb")
Excelchat Expert 06/07/2018 - 05:14
I believe I got the problem. We would need 12 nested IF formulas for 12 months.
User 06/07/2018 - 05:14
yes .. and i need equal or greater within the next IF
Excelchat Expert 06/07/2018 - 05:15
Yeah, I understand. That would be a very long and confusing formula. There is a better alternative. I can do both.
Excelchat Expert 06/07/2018 - 05:15
Would you like to see the alternative one or I should go with the IF?
User 06/07/2018 - 05:16
im comfortable with Iut open to easist way
User 06/07/2018 - 05:16
comfortable with IF
Excelchat Expert 06/07/2018 - 05:17
Okay, I will show the alternative one first.
Excelchat Expert 06/07/2018 - 05:17
Please give me some times.
User 06/07/2018 - 05:17
?
Excelchat Expert 06/07/2018 - 05:17
I need some time to put up the formula.
User 06/07/2018 - 05:18
ok
Excelchat Expert 06/07/2018 - 05:18
In the meantime, if you can, please put the list for the week numbers and there respective months in the spreadsheet.
Excelchat Expert 06/07/2018 - 05:19
Ah, I'm doing it in column J and K, correct me if you see me doing it wrong.
User 06/07/2018 - 05:20
ends at 52
User 06/07/2018 - 05:20
March june sept dec each have 5 weeks
User 06/07/2018 - 05:21
i see -- maybe you are going to do a look up table ?
Excelchat Expert 06/07/2018 - 05:21
Yeah, that is correct.
User 06/07/2018 - 05:21
ok -- got it! I can do that.
Excelchat Expert 06/07/2018 - 05:21
Yeah, I was going to do a VLOOKUP
User 06/07/2018 - 05:22
sounds good -- i can do that ..
User 06/07/2018 - 05:22
appreciate the help
Excelchat Expert 06/07/2018 - 05:22
Great, do you want me to do the IF then?
User 06/07/2018 - 05:22
sure -- like to see what I was stuck on formula wise
Excelchat Expert 06/07/2018 - 05:23
Okay, please extend the time when you are asked.
Excelchat Expert 06/07/2018 - 05:25
=IF(B5<5,"Jan",IF(AND(B5>=5,B5<=8,"Feb",IF(AND(B5>=9,B5<=13),"Mar",IF(AND(B5>=14,B5<=17),"Apr","May")))))
Excelchat Expert 06/07/2018 - 05:26
Here I've done upto Apr.
Excelchat Expert 06/07/2018 - 05:26
I see you have opted against to extend time.
Excelchat Expert 06/07/2018 - 05:27
You can no longer reply in the chat box. In stead you can reply in the spreadsheet if you want.
Excelchat Expert 06/07/2018 - 05:29
Hello, are you there?
Excelchat Expert 06/07/2018 - 05:32
Well, I guess you don't have any question.
Excelchat Expert 06/07/2018 - 05:39
Thank you, I will end the session now.
Excelchat Expert 06/07/2018 - 05:39
Have a great day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.