If only the A or B columns are going to be filled (but not both), I'd
probably use something like

=IF(A1<"",IF(B1="","AwaitingA","CompleteA"),IF(C1 <"",IF(D1="",
"AwaitingB","CompleteB"),""))





In article ,
"br0ke" wrote:

I have the following list (which in real terms goes to 10 variables). I have
tried nested IF's but got nowhere. What is the best way of auto-completing
the Result column

TargetA ActualA TargetB ActualB Result
m/d/y m/d/y CompleteA
m/d/y AwaitingA
m/d/y AwaitingB
m/d/y m/d/y CompleteB