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]

You will need to supply a lot more information than that.

 

[steve the fish]

Im having trouble trying to find your question

Basically it is:

=IF(OR(A1="Hello", B1="Bye"), TRUE, FALSE)

 

[JTL9161]

Updated. I hit entered before finishing the text

 

[Fluff]

Are B3, H3 & N3 where you want to enter the formula?

 

[JTL9161]

Yes. All 3 cells B3, H3 and N3 have "John" in them. Only want 1 name showing. If date is in C3 then John in B3 and remove from H3 and N3, If date in I3 then John in H3 and remove from B3 and N3...and I think you get it if there's a date in O3.

thanks

 

[Fluff]

A formula can only affect the cell it is in, so if B3,H3 & N3 are hard values, then you cannot "remove" them with a formula in another cell.

 

[JTL9161]

A formula can only affect the cell it is in, so if B3,H3 & N3 are hard values, then you cannot "remove" them with a formula in another cell.

So i cannot have a if statement in B3 saying if I3 or O3 does not equal "" then no name in B3, IF I3 and O3 equal "" (blank) then "John" and I put this in B3, H3 and N3. Basically saying if C, I or O are blank then "John" if any contain a date then other 2 should be blank with no 'John" in them I'd put the formula in all 3 columns and change the IF's to the other 2 columns. I'm probably not explaining this as I am thinking it.

 

[Fluff]

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

 

[JTL9161]

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",""))