Forum Discussion
Solved
if statement for multiple date conditions
I'm looking to create an if statement that returns the 4 scenarios listed below. The highlighted scenarios in red are where I seem to be having difficulties. Confirmed Late = Actual Delivery is a...
The problem was that Excel expects a space before AM/PM. I have converted the values for you - see attached.
That makes sense. Apologies for not understanding. I tried the conversion that you gave me and it didn't change the values to right aligned. I've also alternatively tried the text to columns way to format and have had no luck 😕
This seemingly simple task has been the bane of my existence.
This seemingly simple task has been the bane of my existence.
The problem was that Excel expects a space before AM/PM. I have converted the values for you - see attached.