NEED HELP IN CRACKING THE FOLLOWING,

Attachment 456568

FROM THE PICTURE ATTACHED i WOULD LIKE TO DISPLAY THE OUTPUT AUTOMATICALLY, BUT CAN SOMEONE TELL ME HOW?

IF CELLVALUE = 1, THEN
LOOK FOR THE LOCATION OF "A"

IF "A" IS BEFORE "1" THEN
RETURN "EARLY"

ELSEIF "A" IS AFTER "1" THEN
RETURN "LATE"

ELSEIF "A" IS WITHIN 1 (ie, 1=1A) THEN
RETURN "SAME"

ELSE
RETURN "NOT DONE"

PLS HELP