IF OR Statement

[JTL9161]

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

 

[Fluff]

Ok, will you only have one date per row, or could you have a date in all 3 cells?

 

[JTL9161]

You can put a formula into those cells to display John or "" is that what you are trying to do?

Yes. Let me try to water this down. Formula in 3 columns B, H, N. When I put the formula in 1 of the 3 columns (B,H,N) if any of the other 2 columns have a date then blank out other 2 columns. I tried this in cell C3 but its not working

=IF(I3,OR(O3="","John",""))

 

[Fluff]

When I put the formula in 1 of the 3 columns (B,H,N) if any of the other 2 columns have a date then blank out other 2 columns

I have already said that you cannot do that.

 

[JTL9161]

Sorry for the confusion. 1 more question.

I have this formula: =TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",255)),255))

That I want to go from the right of the string and find the first space " " then take the text from that space to the right. Not getting any results.

 

[Fluff]

That is a totally different question & so needs a new thread.