Excel - IF Function Problem - Expert Solution

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

I need to make it so that when I enter a state's abbreviation in one column it adds a specific number of days to a date listed in the previous column. ie: ship date 4.10.18 if the state is NE the next column adds 2 days to the ship date, making the next available delivery date.
Solved by K. F. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/04/2018 - 01:53
User 10/04/2018 - 01:53
I need to make it so that when I enter a state's abbreviation in one column it adds a specific number of days to a date listed in the previous column. ie: ship date 4.10.18 if the state is NE the next column adds 2 days to the ship date, making the next available delivery date.
User 10/04/2018 - 01:54
the days added are determined by the state
Excelchat Expert 10/04/2018 - 01:54
could you send me your document pls ?
User 10/04/2018 - 01:55
Copied and pasted what I have - will get you the states
User 10/04/2018 - 01:57
So I need the next date available to auto populate based on the state entered in column C
Excelchat Expert 10/04/2018 - 01:58
You enterd data in column B ?
User 10/04/2018 - 01:59
So for instance tank 7525 shipped yesterday the state is NE and the next available ship date is 4/11
User 10/04/2018 - 01:59
ship date we enter then we enter the state then the next date available adds the days to the ship date based on the state that was entered
User 10/04/2018 - 02:01
But if you say OR, it adds 9 days
User 10/04/2018 - 02:01
Per the list I pasted
Excelchat Expert 10/04/2018 - 02:02
now i understand
User 10/04/2018 - 02:02
:)
Excelchat Expert 10/04/2018 - 02:03
Are there more than 13 state's abbreviation ?
User 10/04/2018 - 02:03
No I just need these
Excelchat Expert 10/04/2018 - 02:03
great!
User 10/04/2018 - 02:03
This is all we ship to for now
Excelchat Expert 10/04/2018 - 02:09
i will be finished soon
User 10/04/2018 - 02:10
No worries
User 10/04/2018 - 02:24
So is it looking good?
Excelchat Expert 10/04/2018 - 02:24
let me check a little bit
User 10/04/2018 - 02:25
Okay thanks, I can edit - the +4 is NE and WI, not WI and WI - but I can fix those things
Excelchat Expert 10/04/2018 - 02:27
User 10/04/2018 - 02:29
I don't know what you mean - you fixed it
Excelchat Expert 10/04/2018 - 02:29
ok
User 10/04/2018 - 02:31
Well I don't know if you did - that part of the formula looks different than the others. You didn't do + behind any other state abbreviations
User 10/04/2018 - 02:31
but I know you are working on it
User 10/04/2018 - 02:31
:)
Excelchat Expert 10/04/2018 - 02:31
i ve finnished
Excelchat Expert 10/04/2018 - 02:32
its not clear what do you want if you enter "NE".
Excelchat Expert 10/04/2018 - 02:32
if the state is NE the next column adds 2 OR 4 days to the ship date, making the next available delivery date.
User 10/04/2018 - 02:32
User 10/04/2018 - 02:34
It's because you have NE in there twice.
User 10/04/2018 - 02:34
Its only 4 days to add
User 10/04/2018 - 02:35
I took it out.
Excelchat Expert 10/04/2018 - 02:36
i think its fine now everything
User 10/04/2018 - 02:36
What do I need to do now?
Excelchat Expert 10/04/2018 - 02:36
pls check it.
User 10/04/2018 - 02:36
Okay
Excelchat Expert 10/04/2018 - 02:37
change abb. in column C and check if the columd D is ok
Excelchat Expert 10/04/2018 - 02:39
Is there anything I can do for you today ?
User 10/04/2018 - 02:40
No it looks good. Thank you
Excelchat Expert 10/04/2018 - 02:40
It's my pleasure. Please come back and see us soon!
User 10/04/2018 - 02:41
So do I just copy the formula?
Excelchat Expert 10/04/2018 - 02:41
yea, watch the row!

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.