+ Reply to Thread
Results 1 to 5 of 5

How to get an AND function to return back results other than "True and False"

  1. #1
    Registered User
    Join Date
    03-03-2014
    Location
    us
    MS-Off Ver
    Excel 2013
    Posts
    17

    How to get an AND function to return back results other than "True and False"

    Here's my formula
    =AND([@[Tenure (Yrs)]]>=5,[@[2016 Sales]]>=150000)

    (where should i enter high and low? Do i need an if formula nested into it?)

    i'm trying to get it to read if the customer reads both critiera which is they've been there 5 years and over 150000 sales = High
    if not Low

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to get an AND function to return back results other than "True and False"

    =if(AND([@[Tenure (Yrs)]]>=5,[@[2016 Sales]]>=150000),"what do do if true","what to do if false")
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,067

    Re: How to get an AND function to return back results other than "True and False"

    use the IF statement

    =IF(your AND function/formula here, value for if it's true (e.g. "HIGH"), value if it's false (e.g "LOW")).

    You MAY need multiple IF statement

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: How to get an AND function to return back results other than "True and False"

    Try this:

    =If(AND([@[Tenure (Yrs)]]>=5,[@[2016 Sales]]>=150000),"HIGH","LOW")
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    11-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: How to get an AND function to return back results other than "True and False"

    If A1 was your years, and B1 was your sales =IF(AND(A1>=5,B1>=150000),"HIGH","LOW")

+ 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. How can I get a value to return "Y" OR "N" instead of true or false
    By bunnyfrostr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-04-2014, 05:44 PM
  2. VLookup to return "true" or "false"
    By Sph01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2011, 11:10 AM
  3. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  4. Replies: 7
    Last Post: 05-13-2006, 05:02 PM
  5. [SOLVED] IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2005, 01:05 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