show text based on a true and false text conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2646763%22%20slang%3D%22en-US%22%3Eshow%20text%20based%20on%20a%20true%20and%20false%20text%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646763%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ccrossed_0-1628881593937.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303183i4BEDA6FB81BB5B1C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ccrossed_0-1628881593937.png%22%20alt%3D%22Ccrossed_0-1628881593937.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BHello%2C%20I'm%20trying%20to%20format%20a%20cell%20to%20show%20certain%20text%20when%20the%20two%20cells%20on%20the%20left%20have%20specific%20text%2C%20and%20anything%20different%20than%20a%20specific%20text%20respectively.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2646763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646803%22%20slang%3D%22en-US%22%3ERe%3A%20show%20text%20based%20on%20a%20true%20and%20false%20text%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646803%22%20slang%3D%22en-US%22%3E%3DIF(AND(C4%3DTRUE%2CD4%26lt%3B%26gt%3B%22COLLECT%22)%2C%22Good%22%2C%22%22)%20is%20a%20formula%20that%20works.%20Leaves%20the%20cell%20in%20column%20E%20blank%20if%20conditions%20aren't%20met%2C%20otherwise%2C%20when%20the%20conditions%20are%20met%20shows%20as%20%22Good%22%3CBR%20%2F%3E%3CBR%20%2F%3E(If%20it's%20not%20obvious%2C%20this%20was%20copied%20from%20row%20four%3B%20the%20formula%20needs%20to%20be%20copied%20to%20all%20of%20the%20rows%20in%20that%20column%2C%20and%20it%20adjust%20the%20references%20accordingly)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646808%22%20slang%3D%22en-US%22%3ERe%3A%20show%20text%20based%20on%20a%20true%20and%20false%20text%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646808%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128056%22%20target%3D%22_blank%22%3E%40Ccrossed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20row%203%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(AND(C3%2CD3%26lt%3B%26gt%3B%22COLLECT%22)%2C%22Good%22%2C%22Bad%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(AND(C3%2CD3%26lt%3B%26gt%3B%22COLLECT%22)%2C%22Good%22%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%20similar.%20Fill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646810%22%20slang%3D%22en-US%22%3ERe%3A%20show%20text%20based%20on%20a%20true%20and%20false%20text%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646810%22%20slang%3D%22en-US%22%3EPS%20Your%20image%20says%20the%20opposite%20of%20your%20posting.%20The%20posting%20says%20to%20show%20%22Good%22%20if%20column%20C%20is%20%22True%22%2C%20but%20your%20image--which%20I%20didn't%20look%20at%20until%20after%20I%20posted%20my%20first%20reply--says%20that%20column%20C%20should%20show%20FALSE%20and%20something%20other%20than%20%22Collect%22%3CBR%20%2F%3EEither%20way%2C%20the%20formula%20works.%20You%20just%20need%20to%20decide%20what%20condition%20you%20actually%20mean%20to%20apply%20to%20column%20C.%3C%2FLINGO-BODY%3E
Occasional Contributor

Untitled.png

 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.

5 Replies
=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)

@Ccrossed 

In row 3:

 

=IF(AND(C3,D3<>"COLLECT"),"Good","Bad")

 

or

 

=IF(AND(C3,D3<>"COLLECT"),"Good","")

 

or similar. Fill down.

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?

@Ccrossed 

TRUE and FALSE are boolean values, not text strings.