• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to hide false from a if statement?


New Member
Hello guys,

Just a quick check. How do i hide the False value resulting from a if statement

For example, if a drop-down column A1 has the string = "Yes", it should draw a line on A2. I have tried with the format below and it does draw a line but when i change the value in A1, but it shows "FALSE" in A2. I want it to be BLANK

This is the statement in A2 currently =IF(A1="YES","______________")

any help is appreciated.