Forum Discussion
show text based on a true and false text conditions
Hello, I'm trying to format a cell to show certain text when the two cells on the left have specific text, and anything different than a specific text respectively.
In row 3:
=IF(AND(C3,D3<>"COLLECT"),"Good","Bad")
or
=IF(AND(C3,D3<>"COLLECT"),"Good","")
or similar. Fill down.