How would I do this.... Multiple IFs

[Bruccce]

How would I do the following?

I need to get hold of contacts and I try to call them at the time the
requested info, if not, then I will have the next shift try, and then if
not, I would have a diff shift try....
Also, I have some records that have been called randomly, but I want to make
sure that they have been at least attempted 1 time by each shift. The prev
call attempts are in columns BC,BD,BE and are labeled as shift A,B or C. BB
is when we first got the request from the customer. BF is the next time to
attempt

Here is what the flow would be from what I can figure out....


If search(Concatenate(BCx,BDx,BEx),BBx)=0

BFx=BBx

Elseif search(Concatenate(BCx,BDx,BEx),BBx),"A" =0

BFx="A"

Elseif search(Concatenate(BCx,BDx,BEx),BBx),"B" =0

BFx="B"

Elseif search(Concatenate(BCx,BDx,BEx),BBx),"C" =0

BFx="C"

End if



What would be the best way to do this?

Would if be a compound =if statement? Or a function? How would I code the
function?



Thanks

Bruce