Thread: What is the right character for "OR" for the IF function?

Hello everyone

I'm studying an Excel course and I need to use the IF function for some employment table, like this:

If cell E2(employment status) equals I34(salaried employee) OR I35(self-employed), then value_if_true=J36(employed), value_if_false=J38(unemployed). I just don't know what is the right character for "OR". I know that : is for through (cell x through cell y), + is for and (cell x plus cell y), and so on, but I couldn't for the life of me find what is the right one for "OR". Does anybody know?

I'm using Office 2010, if it means anything.

Any help will be greatly appreciated.

maybe

=If(or($E$2=$I$34,$E$2=$I$35),$J$36,$J$38)

or

=If(or(E2=I34,E2=I35),J36,J38)

Check and apply absolute or relative cell referencing according to your needs.