Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Happy Birthday Formula Flag Needed | Excel Worksheet Functions | |||
Calcualtion of renewal | Excel Worksheet Functions | |||
Calcualtion of renewal | Excel Worksheet Functions | |||
Calcualtion of renewal | Excel Worksheet Functions | |||
Help, experts needed! Auto notification | Excel Discussion (Misc queries) |