Flag Needed for Membership Renewal Notification?
 

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan

Flag Needed for Membership Renewal Notification?
 

Try this in J1 (assuming data starts at row 1 without any headers)

=IF(OR(AND(J1="10 Card Class",K1=10),AND(J1="20 Card Class",K1=20)),"Re-New
Class Membership","")

"Danny Boy" wrote:

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan

Flag Needed for Membership Renewal Notification?
 

Hi Sheeloo:

I actually start the formula in Row 4. For some reason the flag did not show
up when using the formula you gave me. I tested in by toggling J4="10 Card
Class", and K4=10, but no flag. I tried the same with the "20 Card Class",
and no luck there either. Any suggestions?

Dan

"Sheeloo" wrote:

Try this in J1 (assuming data starts at row 1 without any headers)

=IF(OR(AND(J1="10 Card Class",K1=10),AND(J1="20 Card Class",K1=20)),"Re-New
Class Membership","")

"Danny Boy" wrote:

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan

Flag Needed for Membership Renewal Notification?
 

Never mind. I got it. Your formula was correct. I am just a bit dyslexic when
I type, lol. Thank you very much!

Dan

"Sheeloo" wrote:

Try this in J1 (assuming data starts at row 1 without any headers)

=IF(OR(AND(J1="10 Card Class",K1=10),AND(J1="20 Card Class",K1=20)),"Re-New
Class Membership","")

"Danny Boy" wrote:

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan

Flag Needed for Membership Renewal Notification?
 

Glad it worked out...

It must be tough on you but we (who are not Dyslexic often do the same)...

If you don't mind, I can't resist sharing the slogan - Dyslexics of the
world - UNTIE.

"Danny Boy" wrote:

Never mind. I got it. Your formula was correct. I am just a bit dyslexic when
I type, lol. Thank you very much!

Dan

"Sheeloo" wrote:

Try this in J1 (assuming data starts at row 1 without any headers)

=IF(OR(AND(J1="10 Card Class",K1=10),AND(J1="20 Card Class",K1=20)),"Re-New
Class Membership","")

"Danny Boy" wrote:

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan

Flag Needed for Membership Renewal Notification?
 

LOVE iT! You made my day.........UNTIE!! :)

"Sheeloo" wrote:

Glad it worked out...

It must be tough on you but we (who are not Dyslexic often do the same)...

If you don't mind, I can't resist sharing the slogan - Dyslexics of the
world - UNTIE.

"Danny Boy" wrote:

Never mind. I got it. Your formula was correct. I am just a bit dyslexic when
I type, lol. Thank you very much!

Dan

"Sheeloo" wrote:

Try this in J1 (assuming data starts at row 1 without any headers)

=IF(OR(AND(J1="10 Card Class",K1=10),AND(J1="20 Card Class",K1=20)),"Re-New
Class Membership","")

"Danny Boy" wrote:

Column J Column K Column L

10 Card Class Drop down Needed Formula
20 Card Class list of numbers
1-20

What I'd like is a formula that flags the word "Re-New Class Membership" if
either of the following conditions are present: (a) Column J is a 10 card
class, and Column K idicates that class #10 has been used, and (b) Column J
is a 20 Card Class, and Column K indicates that class #20 has been used.

The formula in Column L would alert the staff that the member needs to
re-new their 10 or 20 card class membership.

Thanks in advance for the help,

Dan