Formula doesn't work as expected????

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???

Instead of using ISBLANK use:

=IF(Q3="","",IF(Q3,"YES","NO"))

Hi Andrew,

The formula works on a new worksheet but for some reason not on the worksheet I'm using, any ideas??

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.