Results 1 to 9 of 9

Need help with the IF function in Excel 2007

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Gatineau, Canada
    MS-Off Ver
    Excel 2007
    Posts
    11

    Need help with the IF function in Excel 2007

    Hello!
    I need help with an IF function in Excel 2007.
    I need the IF formula to put a "1" if the word "YT" or "BC" or "Pacific_Ocean" is in cell J2:V2. If none of these words are there, I want the IF formula to put a "0".

    I have written the following formula but it contains an error:
    =IF(OR(J2:V2="YT",J2:V2="BC",J2:V2="Pacific_Ocean")"1", "0")
    Can you please help!
    Thanks a lot!
    Last edited by XavierC; 04-15-2013 at 02:30 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1