Hi again Swuehl
AS the formula was pasted It didnt work so I tested different parts to see if I could get it.
The below works :
It seems the "only" function works on 1 side of the IF statement, only if [On target] is Yes make tick .
It doesnt seem to get the second condition if [On target] is not Yes Is it No ? then give me an X if neither give me blank
It ONLY gives the first condition
Any other suggestions ? - I could use as is I Suppose