Hi guys,
I'm pretty new to Excel and pretty lost So hopefully you can help me get around what should be such a simple equation but is resulting in failure
I have this equation in column K:
Where:
A = 1 to 'Infinity' (Currently 1 - 10)
J = Dates to which the job in that row was 'Closed' (Dates in dd/mm/yyyy format)
So, I would like K4 to display:
"" (Nothing) if A4 is less than 0 (Job doesn't exist)
'Open' if A4 is greater than or equal to 1 (Job exists)
'Closed' if there is a date in J4 (Job closed)
However, at the moment, when there is a date in J4, it still returns an answer of 'Open'
What am I doing wrong
Bookmarks