Using or logically

[BladeFisher]

I am trying to write a simple formula where more than one condition needs outcome a.

I would have though something like
=IF(A1="xyz") OR(A1="abc"),"123","789")) would be possible, but no.

What do you do to solve this?

I tried
=IF(A1="xyz", IF(A1="abc"),"123",789) and other permutations and just get in a muddle.

I find the excel help utterly useless for nesting functions sadly.

 

[sous2817]

Something like:

=if(or(A1="xyz",A1="abc"),123,789)

Should work

 

[BladeFisher]

Thank you very much.

Regards

Richard