Results 1 to 9 of 9

IF/ AND problem

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    IF/ AND problem

    PLease forgive the informality of this enquiery, but I am new to this.
    Can anyone assist with the following;
    I can get both of the below formulas to work individually,
    =IF(AND(B3=3,C3="Y"),"WARNING","")
    =IF(AND(B3=1,C3="N"),"WARNING","")
    but would like to combine them to get the same result (if that makes sence).
    Something like
    =IF(AND(B3=3,C3="Y"),(B3=1,C3="N"),"WARNING","")
    Any offers??
    Last edited by Higgy; 11-19-2009 at 07:52 AM. Reason: Improper Title

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