how to hide false from a if statement?

[sivapc]

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.

 

[AliGW]

Like this:

=IF(A1="YES","______________","")

 

[sivapc]

That was quick. TQVM

 

[AliGW]

NP. Quick because it was easy.