+ Reply to Thread
Results 1 to 2 of 2

if with logical operators

  1. #1
    Registered User
    Join Date
    05-12-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    if with logical operators

    Hi my best friends,


    I'm novice and I 've a big problem on my excel formulr

    I can't create a good IF with my excel but my algorithm is good

    IF (M591= "XXX" or M591 = "YYY") and (N591= "AAA" ou N591 = "BBB") then I want "PPP" else value of M591

    How can I succeed and solve my problem?

    thanks a lot

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: if with logical operators

    PHP Code: 
    =if(and(or(m591="xxx",m591="yyy"),or(n591="aaa",n591="bbb")),"ppp",m591
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining Multiple if statements using logical operators
    By arahant16 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2014, 03:49 AM
  2. Replies: 2
    Last Post: 05-13-2013, 02:41 AM
  3. Can logical operators be used within Conditional Formatting?
    By Rumpa Biswas in forum Excel General
    Replies: 8
    Last Post: 12-03-2012, 03:23 AM
  4. Multiple Logical Operators
    By bluesstruggler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-22-2011, 09:27 PM
  5. Syntax for Logical Operators to Limit Input?
    By DCSwearingen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2006, 11:14 AM

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