Which Function to use

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.