formula that will indicate something in column

[mark692]

hi guys i want a formula in column "remarks" that will indicate "Paid" if a name on column "Name" has a "cash" on "Payment" like in this sample thanks!

Book1
	D	E	F	G
1	date	Name	Payment	Remarks
2	4/1/2020	Jon	None	Paid
3	4/1/2020	Jon	Cash	Paid
4	4/2/2020	Mike	none	Paid
5	4/3/2020	Mike	none	Paid
6	4/4/2020	Mike	Cash	Paid
7	4/5/2020	Donna	Cash	Paid
8	4/6/2020	Mina	None
Sheet1

 

[mark692]

How does Post #5 not suit your needs?

Book5
	D	E	F	G
1	Date	Name	Payment	Remarks
2	4/1/2020	Jon	None	Paid
3	4/1/2020	Jon	Cash	Paid
4	4/2/2020	Mike	none	Paid
5	4/3/2020	Mike	none	Paid
6	4/4/2020	Mike	Cash	Paid
7	4/5/2020	Donna	Cash	Paid
8	4/6/2020	Mina	None
Sheet1

Cell Formulas
Range	Formula
G2:G8	G2	=IF(COUNTIFS(E:E,E2,F:F,"cash")>=1,"Paid","")

yes! thank you sir! sorry i didnt see it earlier. thanks again!

 

[vcoolio]

@mark692:

As I mentioned in my post #8:-

Other than that, did you try the formula that mrshl9898 supplied in post #5?

Cheerio,
vcoolio.

 

[mark692]

@mark692:

As I mentioned in my post #8:-

Other than that, did you try the formula that mrshl9898 supplied in post #5?

Cheerio,
vcoolio.

yes thanks sir!

 

[vcoolio]

I'm glad its all sorted out for you.

Cheerio,
vcoolio.