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.
=IF(AND(C4=TRUE,D4<>"COLLECT"),"Good","") is a formula that works. Leaves the cell in column E blank if conditions aren't met, otherwise, when the conditions are met shows as "Good"
(If it's not obvious, this was copied from row four; the formula needs to be copied to all of the rows in that column, and it adjust the references accordingly)
(If it's not obvious, this was copied from row four; the formula needs to be copied to all of the rows in that column, and it adjust the references accordingly)
- PS Your image says the opposite of your posting. The posting says to show "Good" if column C is "True", but your image--which I didn't look at until after I posted my first reply--says that column C should show FALSE and something other than "Collect"
Either way, the formula works. You just need to decide what condition you actually mean to apply to column C.- True, I got them mixed, I have updated it. also I was getting the error #N/A after I tried using C4="FALSE", does the quotations not work on TRUE, FALSE words?
TRUE and FALSE are boolean values, not text strings.
