Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    Location
    Israel
    Posts
    87
    Thanks
    18
    Thanked 0 Times in 0 Posts
    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.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi rfe777,

    The basic syntax is:
    =IF(OR(Test1,Test2),"True","False")
    or:
    =IF((Test1)+(Test2)>0,"True","False")
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Star Lounger
    Join Date
    Mar 2010
    Location
    Israel
    Posts
    87
    Thanks
    18
    Thanked 0 Times in 0 Posts
    Thanks for your help macropod

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •