Formula problem

[brutus6294]

For some reason I'm having difficulty with this formula. All I want to do is look in the value in the next column. If the value is ABC or ABD, return ABCD . These are all text. If it is not, ABC or ABD, return whatever the value was unchanged..
Something along these lines...
=IF(F2='ABD' or F2='ABC','ABCD',F2)

 

[SkipVought]

Hi,

use "doubel quotes" to delimit text.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[SkipVought]

Hi,

use "double quotes" to delimit text.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[brutus6294]

Still having an issue.. Must be Monday!!!

=IF((F4="ABC" or F4="ABD"),"ABCD",F4)

My or statement is incorrect... If I take it out, works ok.. Is my syntax wrong?
Thanks!!

 

[SkipVought]

Sorry, I missed the OR thing...
[tt]
=IF(OR(F4="ABC",F4="ABD"),"ABCD",F4)
[/tt]


Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[AnotherHiggins]

-> Is my syntax wrong?

yes

=Or(condition1, condition2)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.