Results 1 to 9 of 9

IF/ AND problem

Threaded View

Higgy IF/ AND problem 11-19-2009, 07:12 AM
zbor Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:16 AM
t_e_k Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:20 AM
DonkeyOte Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:25 AM
Higgy Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:32 AM
DonkeyOte Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:39 AM
Higgy Re: Helllllppppppppp! IF/ AND... 11-19-2009, 07:46 AM
Higgy Re: IF/ AND problem 11-19-2009, 07:56 AM
DonkeyOte Re: IF/ AND problem 11-19-2009, 07:58 AM
  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