Hi,

I have a worksheet with the following formula =IF(P3="","",COUNTIF($P$3:P10000,P3)>1) which gives me a true/false or blank result from a unique id in another column, I then have a =IF(ISBLANK(Q3),"",IF(Q3=TRUE<"YES","NO")) which gives me the desired yes/no/blank result in another column(or is supposed to), the problem is the ISBLANK formala doesn't return a blank if the previous column is blank it still returns a fals value.
I'm sure there is an explenation for this however I don't know what thatis???