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

IF(AND(D2<>"",G2<>"","Completed”, “Outstanding"))

but it isn’t working can anybody suggest a solution or where I’ve gone wrong? Any help gratefully appreciated.