SOLVED

Leave the Cell Blank When Either Cell is Empty

Copper Contributor

Hi All,

 

I would like to know how to leave the cell D4 empty (Don't want to show "Don't match") when either cell B4 or C4 is not filled? Same goes the row 5 as well.

 

renjie0315_0-1676629343341.png

 

3 Replies
best response confirmed by renjie0315 (Copper Contributor)
Solution

@renjie0315 

=IF(OR(B3="",C3=""),"","Don't match")

You can try this formula.

Don't match.JPG 

Hi @OliverScheurich,

 

Is there any method to achieve this combination? When both values are the same, display "Match". When 1 value is not inserted, don't display. When values are not matched, display "Don't Match".

 

renjie0315_0-1676686244361.png

 

I have successfully found the answer:

=IF(OR(B3="",C3=""),"",IF(EXACT(B3,C3),"Match","Don't match"))
1 best response

Accepted Solutions
best response confirmed by renjie0315 (Copper Contributor)
Solution

@renjie0315 

=IF(OR(B3="",C3=""),"","Don't match")

You can try this formula.

Don't match.JPG 

View solution in original post