Which Function to use

%3CLINGO-SUB%20id%3D%22lingo-sub-2378460%22%20slang%3D%22en-US%22%3EWhich%20Function%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378460%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20a%20table%20like%20this%3A%3C%2FP%3E%3CP%3EI%20need%20to%20check%20if%20Tracking%20column%20has%20%22Tracked%22%20but%20if%20the%20Billing%20Complete%20column%20has%20%22Billing%20Comp%22%20the%20validate%20column%20needs%20to%20show%200%20otherwise%20say%20Tracked.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%3C%2FP%3E%3CP%3E%3CU%3EIF%20%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EF%3C%2FFONT%3E%20%3C%2FSTRONG%3E%3D%20%22Tracked%22%20and%20%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EA%3C%2FFONT%3E%20%3C%2FSTRONG%3E%26lt%3B%26gt%3B%200%2C%20then%20show%20Tracked%20otherwise%20leave%20blank%3C%2FU%3E%3C%2FP%3E%3CTABLE%20width%3D%22531px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EA%3C%2FFONT%3E%20-%3C%2FSTRONG%3E%20Billing%20Complete%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EB%3C%2FFONT%3E-%3C%2FSTRONG%3ETested%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E%3CP%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EC%3C%2FFONT%3E-%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EMS%20Fees%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3ED-%3C%2FSTRONG%3E%3C%2FFONT%3EFixed%20Fee%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EE%3C%2FFONT%3E%20-%3C%2FSTRONG%3EBill%20No%20Pay%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EF%3C%2FFONT%3E-%20%3C%2FSTRONG%3ETracking%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%3CSTRONG%3E%3CFONT%20color%3D%22%23FF0000%22%3EE%3C%2FFONT%3E-%20%3C%2FSTRONG%3EValidate%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3EBilling%20Comp%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3ETracked%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3EBilling%20Comp%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3EBilling%20Comp%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3ETracked%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3EBilling%20Comp%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3ETracked%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3ETracked%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22108.8px%22%20height%3D%2256px%22%3EBilling%20Comp%3C%2FTD%3E%3CTD%20width%3D%2258.4px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2287.2px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2264px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2265.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2273.6px%22%20height%3D%2256px%22%3E0%3C%2FTD%3E%3CTD%20width%3D%2272px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2378460%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-2378489%22%20slang%3D%22en-US%22%3ERe%3A%20Which%20Function%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1060818%22%20target%3D%22_blank%22%3E%40MzVaughn3%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20try%20this%20formula%20in%20your%20column%20E%2C%20and%20then%20copy%20it%20down%20the%20column%3B%20I%20think%20it's%20what%20you're%20seeking.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(AND(F5%3D%22Tracked%22%2CA5%3CFONT%20color%3D%22%23FF0000%22%3E%26lt%3B%26gt%3B%3C%2FFONT%3E0)%2C%22Tracked%22%2C%22%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20to%20use%20%220%22%20in%20the%20evaluation%20of%20A5%20because%20that's%20the%20value%20in%20it%3B%20it's%20not%20actually%20blank.%20If%20your%20real%20one%20is%20blank%2C%20then%20substitute%20%22%22%20for%20the%200.%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So I have a table like this:

I need to check if Tracking column has "Tracked" but if the Billing Complete column has "Billing Comp" the validate column needs to show 0 otherwise say Tracked. 

I am not

IF F = "Tracked" and A <> 0, then show Tracked otherwise leave blank

A - Billing CompleteB-Tested

C-

MS Fees

D-Fixed FeeE -Bill No PayF- TrackingE- Validate
Billing Comp0000Tracked 
Billing Comp00000 
Billing Comp0000Tracked 
Billing Comp 00000 
00000Tracked 
00000Tracked 
Billing Comp00000 
1 Reply

@MzVaughn3 

 

But try this formula in your column E, and then copy it down the column; I think it's what you're seeking.

=IF(AND(F5="Tracked",A5<>0),"Tracked","")

 

I had to use "0" in the evaluation of A5 because that's the value in it; it's not actually blank. If your real one is blank, then substitute "" for the 0.