July 17, 2018
Hi All I wonder if anybody could assist?
I have a sheet “Data” with some formulas that return values based on certain conditions being met.
I’m having trouble with one of the formulas which I can’t seem to get right.
In Column H “Assets in Production” I want it to display either “Outstanding” or “Completed” based on two conditions.
If Colum D ”Allocation Date” is not blank and Column G “ Actual Sign off Date” is also not blank then I would like it to display “Completed” otherwise Display “Outstanding”
The formula I’m trying to use is this
but it isn’t working can anybody suggest a solution or where I’ve gone wrong? Any help gratefully appreciated.