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

 

[mole999]

=if(OR(F2="Cash",F2="Payment","Paid",""))

like that, it may need brackets changing

 

[vcoolio]

Hey Mole999,

I think that the OP is referring to "Payment" as being the header. I could be wrong but that's how I interpret his explanation.

Perhaps:-

=IF(F2="Cash","Paid","")

Don't be afraid to scold me if I'm wrong!

Cheerio,
vcoolio.

 

[mark692]

Hey Mole999,

I think that the OP is referring to "Payment" as being the header. I could be wrong but that's how I interpret his explanation.

Perhaps:-

=IF(F2="Cash","Paid","")

Don't be afraid to scold me if I'm wrong!

Cheerio,
vcoolio.

thank you i used your formula but it didnt give all the name paid
ex.

the name Mike should have a "Paid" remarks in G4 and G5,

Book1
	D	E	F	G
1	Daete	Name	Payment	Remarks
2	4/1/2020	Jon	None
3	4/1/2020	Jon	Cash	Paid
4	4/2/2020	Mike	none
5	4/3/2020	Mike	none
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(F2="Cash","Paid","")

 

[mrshl9898]

=IF(COUNTIFS(E:E,E2,F:F,"cash")>=1,"Paid","")

 

[vcoolio]

Hello Mark,

From what I understand from your opening post, you only need "Paid" in Column G if "Cash" is entered in Column F.
Is this correct?

Cheerio,
vcoolio.

 

[mark692]

Hello Mark,

From what I understand from your opening post, you only need "Paid" in Column G if "Cash" is entered in Column F.
Is this correct?

Cheerio,
vcoolio.

i want "paid" in column G if the name on in column E has a "Cash" on column F, that is what i mean sir

 

[vcoolio]

Hello Mark,

"i want "paid" in column G if the name on in column E has a "Cash" on column F, that is what i mean sir"

If we remove the excess prepositions, which are causing confusion, from your last reply:-

"i want "paid" in column G if the name in column E has "Cash" in column F, that is what i mean sir "

you'll be able to see that the formula in post #3 does exactly what you ask.

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

Cheerio,
vcoolio.

 

[mark692]

Hello Mark,

"i want "paid" in column G if the name on in column E has a "Cash" on column F, that is what i mean sir"

If we remove the excess prepositions, which are causing confusion, from your last reply:-

"i want "paid" in column G if the name in column E has "Cash" in column F, that is what i mean sir "

you'll be able to see that the formula in post #3 does exactly what you ask.

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

Cheerio,
vcoolio.

i see to make it more clearly, i want a "paid" on all of the same name if one of them in column E has "cash", like my sample table on post number 1

 

[Scott Huish]

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","")