Flag Needed for Membership Renewal Notification?

[Danny Boy]

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

 

[Sheeloo]

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]

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

 

[Danny Boy]

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]

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]

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

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.