Results 1 to 8 of 8

3 conditions coming from one cell.. Nested If Statement??

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2012
    Location
    Davie, FL
    MS-Off Ver
    Excel 2013
    Posts
    83

    3 conditions coming from one cell.. Nested If Statement??

    Can someone please help me out with this formula? In English I’m trying to say:
    If the words “CANCEL”, “Cancel – Non-Pay”, or “Cancel-Pend Rel/NOC” are in column A, then count as 1, if not 0..

    This is what I thought was right…Apparently not..

    =IF(or(A:A=”CANCEL”,”Cancel – Non-Pay”,”Cancel-Pend Rel/NOC”,1,0))

    What did I do wrong?
    Last edited by trosasco; 05-10-2013 at 02:42 PM.

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