JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
Having trouble with (I think is) a IF OR statement.
I have a name in 3 different columns.
John is in B3, H3 and N3
If a date is entered in C3 I want the names in H3 and N3 to disappear.
If a date is entered in I3 I want the names in B3 and N3 to disappear.
If a date is entered in O3 I want the names in B3 and H3 to disappear.
I can get the first argument to work but not the 2nd.
Thanks in advance for your help.
James
I have a name in 3 different columns.
John is in B3, H3 and N3
If a date is entered in C3 I want the names in H3 and N3 to disappear.
If a date is entered in I3 I want the names in B3 and N3 to disappear.
If a date is entered in O3 I want the names in B3 and H3 to disappear.
I can get the first argument to work but not the 2nd.
Thanks in advance for your help.
James