+ Reply to Thread
Results 1 to 2 of 2

Logical Function Help

  1. #1
    Registered User
    Join Date
    10-29-2008
    Location
    Texas
    Posts
    7

    Logical Function Help

    Hey all,
    I'm still learning how to use all the functions and I need some help. I need to combine two IF statements but can't get the syntax right. The first is easy: IF(A-B>=3,"Don't Count","Count"). The second should basically say: if B=0 and A>=2,"Don't Count","Count". How do I combine those statements? Any help would be appreciated.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    You need to define exactly what you want to do, If the first condition is satisfied, i.e A-B>=3 then presumably you want "Don't count" whatever the result of your condition? If so perhaps

    =IF(OR(A-B>=3,AND(B=0,A>=2)),"Don't Count","Count")

    so that applies "Don't Count" if either condition is TRUE

    If that doesn't work for you then try posting some sample data (just a small amount will do) and expected results

+ Reply to Thread

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