function that accounts for two different text strings

[abrunstad]

hello,

I want to make an if function that accounts for two text strings;


=if(b3="tekst1" OR "tekst2";"";b4+b5)

My problem is that I do not know how to tell exel the OR function.

Anyone? thanks!

[sweep]

Hi,

Try this,

=IF(OR(b3="tekst1";"tekst2");"";b4+b5)

[Ron Coderre]

Try this:

=IF(OR(B3={"tekst1","tekst2"}),"",B4+B5)
or...a variation of that...
=IF(OR(B3="tekst"&{1,2}),"",B4+B5)

Does that help?

[abrunstad]

thnx guys,

thw following works form me;

=HVIS(ELLER(B3={"tekst1";"tekst2"});"";B4+B5)


note that ; = , in the english version